LEFT

Returns a sub-string from the left part of a text string.

Syntax:

LEFT(text {, length})

Returns the leftmost length characters of the text string.

If the length parameter is omitted, 1 is assumed.

Starting with 2.00, a length of zero is allowed (for consistency with the MID() function).

For example:

LEFT("Thunderbird", 7)

returns the text string "Thunder".