ODBC API and Scalar Functions : Scalar Functions

Scalar Functions
This section lists the scalar functions that ODBC supports. Your database system may not support all these functions. Refer to the documentation for your database system to find out which functions are supported. Also, depending on the driver that you are using, all the scalar functions may not be supported. To check which scalar functions are supported by a driver, use the SQLGetInfo ODBC function.
You can use these scalar functions in SQL statements using the following syntax:
{fn scalar-function}
where scalar-function is one of the functions listed in the following tables. For example:
SELECT {fn UCASE(NAME)} FROM EMP
String Functions
Numeric Functions
Date and Time Functions
System Functions

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.