Right ( string, n )
| Argument | Description | ||
|---|---|---|---|
| string | The string from which you want characters returned. | n | A long whose value is the number of characters you want returned from the right end of string. |
Data type: String Returns the rightmost n characters in string if it succeeds and the empty string (“”) if an error occurs. If n is greater than or equal to the length of the string, Right returns the entire string. It does not add spaces to make the return value’s length equal to n.
Example 1
Section titled “Example 1”Right('CASTLE HILL', 4)
This expression returns HILL
Right('CASTLE HILL', 75)
Example 2 This expression returns CASTLE HILL