skip to main content
SQL Escape Sequences : Scalar Functions
 

Try DataDirect Cloud Now

Scalar Functions

Scalar functions are specific to each type of data store. Refer to the documentation for the data source to which you are connection.
The driver supports a variety of scalar functions, which return a single value based on the input value. The SQLGetInfo function returns information about supported functions.
Applications can construct SQL statements using the following syntax:
{fn scalar-function}
For example:
SELECT {fn UCASE(NAME)} FROM EMP
Applications connecting through JDBC can use the following scalar functions in expressions. For syntax details, consult your JDBC documentation.