Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the last character or characters in a text string, based on the number of characters you specify.
Syntax
RIGHT(text [, num_chars_opt ])
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| text |
Required |
String |
The text string containing the characters you want to extract. |
| num_chars_opt |
Optional |
Number |
The number of characters you want to extract. The default is 1. |
Return value
String
Remarks
The value of num_chars_opt must be greater than or equal to zero (0).
If num_chars_opt is greater than the length of the text, RIGHT returns all of the text. If num_chars_opt is omitted, it is assumed to be 1.
Example
RIGHT ("January 1, 2004", 4)
Returns the value 2004.