You are here: Functions > LEFT()

LEFT()

LEFT() returns a specified number of characters from the beginning of a string.

Function Format

LEFT(C,#)

•

C is the source string and # is a numeric constant.

LEFT() returns a string containing the first # of characters from the left (beginning) of string C. When the number of characters requested exceeds the string length, the entire string is returned.

Examples

LEFT("abcdefghi",5) = "abcde"

LEFT("abc",6) = "abc"