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 2000 Driver for JDBC, 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
SQL Server 2000
ASCII
CHAR
CONCAT
DIFFERENCE
INSERT
LCASE
LEFT
LENGTH
LOCATE
LTRIM
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
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