Navigation:  Advantage SQL > Supported SQL Grammar >

Supported Scalar Functions

Advantage SQL Engine

Previous pageReturn to chapter overviewNext page

Advantage supports a number of different scalar functions that can be used within SQL statements and in navigational usage (e.g., in direct table filters and index expressions). For historical reasons and because of slight semantic differences and keyword conflicts, not all scalar functions can be used in each of those two environments. But many scalars can be used both in index expressions and in SQL statements. The documentation for each scalar indicates where it is supported. The following types of scalars are supported:

Math Functions

String Functions

Date/Time Functions

Miscellaneous Functions