LEFT

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

Syntax:

LEFT(text {, length:Number})

Returns the leftmost length characters of the text string.

If the length parameter is omitted, 1 (one) is assumed.

Example:

LEFT("Thunderbird", 7)

returns the text string "Thunder".

Revisions:

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