LEFT (left part of a text string)

<< Click to Display Table of Contents >>

LEFT (left part of a text string)

Syntax:

LEFT(TextString [, n])

Description:

This returns the first n characters of a TextString.

If n is omitted, the function only returns the first character.

Example:

LEFT("peanut", 3) returns pea

LEFT("peanut") returns p

See also:

RIGHT, MID, REPLACE, LEN