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