Left

left returns the leftmost characters from a string, including spaces. You specify the number of characters to be returned.

Syntax

Copy
left(expression, limit)

Arguments

expression

The expression must be a string. It can be the name of a field that uses the string data type, a literal value like '12 Main Street', or a call to another function that outputs a string.

limit

The number of characters to be returned from expression, starting from the first character in the string.

Return type

String

Example

The following example returns the first three characters from a string.

Copy
left('Seattle Store #14', 3)

The following value is returned.

Copy
Sea