Operator/Function Reference

The operator/function reference defines each operator and function in the following format:

Syntax: NAME(D parameter)  
Return Value: D return_value  
Precedence:1 15
Description: Description of the operator or function  
Example: Example usage and results  

The components of the syntax and return value are shown as:

NAME Name of the function or operator
D Data type of the parameter, as defined in the data type table on page ?
Where a C is specified, U, P, S and M data types may also be used. Where an N data type is specified, the I and L data types can also be used
Where more than one data type can be passed, these are listed (for example, NDT for Number, Date and Time). Multi-occurs data types are indicated by the following syntax: [..]
parameter Descriptive name of the parameter
  Where more than one parameter is passed, each parameter is separated by a comma
return value Descriptive name for the return value

The following functions are available: