LEFT (left part of a text string)

<< Click to Display Table of Contents >>

LEFT (left part of a text string)

Syntax:

LEFT(Text [, n])

Description:

Returns the first n characters of Text.

If n is omitted, only the first character is returned.

Example:

LEFT("peanut", 3) returns pea

LEFT("peanut") returns p

See also:

RIGHT, MID, REPLACE, LEN