Left()

Left ( string, n ) | Argument | Description | | string | The string containing the characters you want | | n | A long specifying the number of characters you want | Returns

Data type: String Returns the leftmost n characters in string if it succeeds and the empty string (“”) if an error occurs. If n is greater than or equal to the length of the string, Left returns the entire string. It does not add spaces to make the return value’s length equal to n.

Example 1

This expression returns BABE:

Left('BABE RUTH', 4)

Example 2

This expression returns BABE RUTH:

Left('BABE RUTH', 40)