Try OpenEdge Now
skip to main content
SQL Reference
ODBC Reference : ODBC Scalar Functions : Scalar functions
 

Scalar functions

The tables in the following sections 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
* String functions
* Numeric functions
* Date and time functions