LEFT

Returns a substring from the beginning of a specified string.

Usage examples 

• LEFT("Hello world", 5)

• LEFT(tableA.fieldB, 3)

Syntax 

LEFT ( value, [ number ] )

• value - any string expression representing from which the left portion will be returned.

• number - any numeric expression representing the number of characters to return from the left side of string.

Returns 

string - the substring from the left.

Functions reference