First Function

Description:

The first member of a list.

Returns:

Any

Parameter:

Parameter	Data Type	Description
1	Any*	The list.

Examples:

When using functions inside a field, remember the field brackets:

{First(VariableName)}

Most Often used on a select statement to ensure only 1 row is returned:

{First(Select ClientAddress from Clients Where ClientName is BuyerName)}

Expression	Result
First( List("a","b","c") )	"a"
First( List( "a" ) )	"a"

This article applies to: