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.