LEFT(text, num_chars)

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:

Other text functions