LEFT


Description Returns the leftmost characters from the specified text string.

Syntax LEFT ( text [, num_chars] )

Argument Description
text Any text string.
[num_chars] Optional. The number of characters to return. This value must be greater than or equal to zero. If num_chars is greater than the number of characters in text, the entire string is returned. If this argument is omitted, 1 is used.

Examples This function returns 2:

LEFT("2nd Quarter")

This function returns 2nd:

LEFT("2nd Quarter", 3)

See Also MID, RIGHT