Using Functions

The functions that are available depend on the type of database you are connected to. Each function has a name and a list of argument data types. The argument data types supported in the SQL Statement Builder are as follows:

num – a number of any kind

int – an integer

char – a character string

date – a date or time

For a range of values that these arguments accept, refer to your relational database documentation.

NOTE: The special function COUNT (*) is appended if record grouping is in effect.

See Also

Building Expressions