Function LEFT

Returns a specified number of characters from the beginning (left) of a text

Usage

LEFT(text, num_chars)

text	(Required) The text from which to extract characters.
num_chars	(Required) The number of characters to extract from the left of the text.

The LEFT function extracts characters from the beginning (left) of the text up to the num_chars limit.

If num_chars is greater than the length of the text, the entire text is returned.