SQL functions

Claris provides an implementation of the SQL standard for the FileMaker Platform and supports many functions you can use in expressions. Some of the functions return characters strings, some return numbers, some return dates, and some return values that depend on conditions met by the function arguments.

• Aggregate functions

• Functions that return character strings

• Functions that return numbers

• Functions that return dates

• Conditional functions