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"
.