Scalar functions

The tables in this topic list the scalar functions that ODBC supports.

Syntax

You can use these functions in SQL statements using the following syntax:

{fn scalar-function}

scalar-function is one of the functions listed in the following tables.

Example

SELECT {fn UCASE(NAME)} FROM EMP