RIGHT


Description Returns the rightmost characters from the given text string.

Syntax RIGHT ( text [, num_chars] )

Argument Description
text Any text string.
[num_chars] Optional. The number of characters to return. The value must be greater than or equal to zero. If num_chars is greater than the number of characters in text, the entire string is returned. If this argument is omitted, 1 is used.

Examples This function returns r:

RIGHT("2nd Quarter")

This function returns Quarter:

RIGHT("2nd Quarter", 7)

See Also LEFT, MID