Supported Scalar Functions

The driver supports the scalar functions in the following table. Note that your database system may not support all these functions. Refer to the documentation for your database system to find out which functions are supported by your database.

In addition, you can also determine the supported scalar functions by using DatabaseMetaData methods.

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

{fn scalar-function}

where:

Example:

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

For descriptions of scalar functions, refer to Scalar Functions in the Progress DataDirect for JDBC Drivers Reference.