skip to main content
Supported scalar functions : Scalar function support for Microsoft SQL Server
 

Try DataDirect Cloud Now

Scalar function support for Microsoft SQL Server

The table identifies the scalar functions that DataDirect Cloud supports for Microsoft SQL Server.
Applications connecting through JDBC or ODBC can use the following scalar functions in expressions. For syntax details, consult your JDBC or ODBC documentation.
Table 32. Scalar Functions
String Functions
Numeric Functions
Timedate Functions
System Functions
ASCII
ABS
CURDATE
DATABASE
CHAR
ACOS
CURTIME
IFNULL
CONCAT
ASIN
DAYNAME
USER
DIFFERENCE
ATAN
DAYOFMONTH
INSERT
ATAN2
DAYOFWEEK
LCASE
CEILING
DAYOFYEAR
LEFT
COS
EXTRACT
LENGTH
COT
HOUR
LOCATE
DEGREES
MINUTE
LTRIM
EXP
MONTH
REPEAT
FLOOR
MONTHNAME
REPLACE
LOG
NOW
RIGHT
LOG10
QUARTER
RTRIM
MOD
SECOND
SOUNDEX
PI
TIMESTAMPADD
SPACE
POWER
TIMESTAMPDIFF
SUBSTRING
RADIANS
WEEK
UCASE
RAND
YEAR
ROUND
SIGN
SIN
SQRT
TAN
TRUNCATE