Description
Returns the rightmost characters from the given text string.
Syntax
RIGHT ( text [, num_chars] )
| Parameter | Description |
|---|---|
| text | Any text string. |
| num_chars | The number of characters to return. This 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. Omitting this argument assumes a value of 1. |
Examples
This function returns r:
RIGHT("2nd Quarter")
This function returns Quarter:
RIGHT("2nd Quarter", 7)
See also