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 driver, as listed in the following table.

Example:

SELECT id, name FROM emp WHERE name LIKE {fn UCASE('Smith')}

Refer to Scalar functions in the Progress DataDirect for JDBC Drivers Reference for more information.

Table 1. Scalar functions
String Functions Numeric Functions Timedate Functions System Functions
ASCII ABS CURDATE CURSESSIONID
BIT_LENGTH ACOS CURTIME DATABASE
CHAR ASIN DATEDIFF IDENTITY
CHAR_LENGTH ATAN DAY USER
CHARACTER_LENGTH ATAN2 DAYNAME IFNULL
CONCAT CEILING DAYOFMONTH
DIFFERENCE BITAND DAYOFWEEK
HEXTORAW BITOR DAYOFYEAR
INSERT BITXOR EXTRACT
LCASE COS HOUR
LEFT COT MINUTE
LENGTH DEGREES MONTH
LOCATE EXP MONTHNAME
LOCATE_2 FLOOR NOW
LOWER LOG SECOND
LTRIM LOG10 TO_CHAR
OCTET_LENGTH MOD WEEK
RAWTOHEX PI YEAR
REPEAT POWER
REPLACE RADIANS
RIGHT RAND
RTRIM ROUND
SOUNDEX SIGN
SPACE SIN
SUBSTR SQRT
SUBSTRING TAN
UCASE TRUNCATE
UPPER ROUNDMAGIC