Scalar Functions


You can use scalar functions in SQL statements with the following syntax:

{fn scalar-function} 

where scalar-function is a scalar function supported by the Microsoft SQL Server driver, as listed in Table D-1.

Example:
SELECT {fn UCASE(NAME)} FROM EMP 

Table D-1. Scalar Functions Supported 
Data Store
String
Functions
Numeric Functions
Timedate
Functions
System
Functions
Microsoft SQL Server
ASCII
BIT_LENGTH
CHAR
CONCAT
DIFFERENCE
INSERT
LCASE
LEFT
LENGTH
LOCATE
LTRIM
OCTET_LENGTH
REPEAT
REPLACE
RIGHT
RTRIM
SOUNDEX
SPACE
SUBSTRING
UCASE
ABS
ACOS
ASIN
ATAN
ATAN2
CEILING
COS
COT
DEGREES
EXP
FLOOR
LOG
LOG10
MOD
PI
POWER
RADIANS
RAND
ROUND
SIGN
SIN
SQRT
TAN
TRUNCATE
CURDATE
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURTIME
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
EXTRACT
HOUR
MINUTE
MONTH
MONTHNAME
NOW
QUARTER
SECOND
TIMESTAMPADD
TIMESTAMPDIFF
WEEK
YEAR
DBNAME
IFNULL
USERNAME


Previous Document Previous Page Next Document Next Page Synchronize TOC Synchronize with Contents