You are here: Functions > RIGHT()

RIGHT()

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

Note: Same as the LAST() function.

Function Format

RIGHT(C,#)

•

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

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

Examples

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

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

RIGHT("abc",6) = "abc"