You are here: Functions > LAST()

LAST()

LAST() returns a specified number of characters from the end of a string.

Note: Same as the RIGHT() function.

Function Format

LAST(C,#)

•

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

LAST() returns a string containing the last # of characters from the end of string C. When the number of characters requested exceeds the string length, the entire string is returned.

Examples

LAST("abcdefghi",5) = "efghi"

LAST("abcdefghi ",5) = "ghi "

LAST("abc",6) = "abc"