Aggregate

Perform aggregate calculations on values in SELECT queries containing a GROUP BY clause.

Case

Evaluation expressions to return expressions based on comparisons.

Cast

Convert to a specified data type.

Date

Manipulate and return dates.

Environment

Manipulate or return information from the operating environment.

Foreign Exchange

FX functions.

GST

For obtaining GST rates and calculating GST.

Number

Manipulate numbers.

Period

Manipulate and work with period IDs.

String

Manipulate strings.