Extracts a string of specified length from the end of another string.
n is the length of the substring you want to extract. The length can be a constant, a numeric field, an expression that results in a number or a function that returns a number.
This function returns a character string.
Calculated field example
If the Company field contained the value Widgets Inc., the following calculated field expression would return Inc.: Right(Company,4)
Note: Right(Company,4) returns the last four characters in the Company field. If the Company field contains trailing spaces, use the RTrim function inside the Right function to first remove the trailing spaces, as in Right(RTrim(Company,4))
Records with a Company field value of Xerox Corp. or FMC Corp. can be selected or found using the expression: Right(RTrim(Company),5)="Corp."