Introduction to SQL functions

Functions are used to return information from the database. They are allowed anywhere an expression is allowed.

Unless otherwise specified in the documentation for a function, NULL is returned if any argument is NULL.

Functions use the same syntax conventions used by SQL statements. For a complete list of syntax conventions, see Syntax conventions.