Functions

A function consists of its function name and parameters. It is used to calculate a value or returns a table (table function). Functions can be called from within expressions. When an expression is evaluated, any function which occurs in the expression is evaluated and replaced by the calculated value or the table which is returned.

SESAM/SQL functions fall into two groups:

• Time functions

• String functions

• Numeric functions

• Aggregate functions

• Table functions

• Cryptographic functions

• User Defined Functions (UDFs)