The LEFT function returns the left-most characters from a text string.
num_chars is the number of characters from the left of the text string. If this is omitted, it is assumed to be 1; if it is greater than the number of characters in text, then LEFT will return the whole text string.
For example:
LEFT("WC1 5NH", 3)
returns "WC1".
See also: