RIGHT

Returns the last (or rightmost) character or characters in a text string.

Syntax

RIGHT(text,num_chars)

Text   is the text string containing the characters you want to extract.

Num_chars   specifies how many characters you want to extract.

• Num_chars must be greater than or equal to zero.
• If num_chars is greater than the length of text, RIGHT returns all of text.
• If num_chars is omitted, it is assumed to be 1.

Examples

RIGHT("Sale Price", 5) equals "Price"

RIGHT("Stock Number") equals "r"

RIGHT is similar to LEFT; for more examples, see LEFT.