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.