Name

left — Return the specified number of characters from the start of a string.

Syntax

left(string, width)
              

The LEFT function has the following arguments:

string

The string to extract the substring from.

width

The width of the substring to extract.

Description

Returns the first characters in a text string, based on the number of characters you specify.

Examples

Formula

Description

Result

left('foobar', 3)

Return the first 3 characters of 'foobar'

'foo'