Returns a specified number of characters from a character expression, starting with the leftmost character.
Syntax
LEFT(cExpression, nExpression)
Returns
Character
Arguments
cExpression
Specifies the character expression from which LEFT( ) returns characters.
nExpression
Specifies the number of characters returned from the character expression. If nExpression is greater than the length of cExpression, all of the character expression is returned. The empty string is returned if nExpression is negative or 0.
LEFT( ) is identical to SUBSTR( ) with a starting position of 1.