Scalar functions

Scalar functions

The solidDB^® server supports the use of direct function names.

For example:

SELECT substring(line, 1,4) FROM test;

However, functions whose names match reserved words must be enclosed with escape characters (double quotation marks). For example:

SELECT "left"(line,4) FROM test;

or:

SELECT {fn left(line,4)} FROM test;

The latter example corresponds to the ODBC implementation-independent syntax. It can be used in all interfaces.