Description
Extracts the specified number of characters from the left side of the string.
Arguments
length is a whole number indicating the number of characters to be extracted from str.
Action
Extracts the specified number of characters from the left side of the string.
Typical uses
Use this function to obtain a certain number of characters from the left end of a text string. For instance, you could use the Left function to obtain just the area code from the values in a field containing phone numbers.
Examples
Left("abcdefg", 4)
Returns "abcd".
Left({customer.FAX}, 3)
Retrieves the area code of each fax number when the first three characters of the Fax field contains the area code.