LEFT

Returns the first n characters of a text.

Syntax

LEFT(text; numChars)

• text - the text from which the left part should be extracted - Value type: text

• numChars - the number of characters which should be returned - Value type: integer

Remarks

• If numChars is < 1, an empty text is returned.

• If numChars is equal or greater than the length of text, the whole text is returned.

Examples