Function reference
Obtains a specified number of characters from the end of a string.

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
This expression returns HILL
Right(‘CASTLE HILL’, 4)

Example 2
This expression returns CASTLE HILL
Right(‘CASTLE HILL’, 75)

Need more help with this?

Thanks for your feedback.