LEFT()

    Extracts a specified number of characters from the left of a character
string.

Syntax

    LEFT(<expC>,<expN>)

Argument

    <expC> is a character string from which to extract characters.

    <expN> is the number of characters to extract.

Returns

    A character string.

    LEFT() returns the leftmost <expN> characters of <expC>.  If <expN> is
negative or zero, LEFT() returns a null string ("").  If <expN> is
larger than the length of the character string, LEFT() returns the
entire string.  The maximum size of <expC> is 65,535 (64K) bytes.