THE function

The THE function returns the first element of a list.

Syntax

Read syntax diagramSkip visual syntax diagramTHE(ListExpression)

If ListExpression contains one or more elements; THE returns the first element of the list. In all other cases, it returns an empty list.

Restrictions

ListExpression must be a SELECT expression.