RIGHT( )
Extracts a substring from a string, starting from the right-most, or last, character.
Syntax
RIGHT(source)
RIGHT(source, n)
Arguments
source
The string from which to extract a substring.
n
The number of characters to extract, starting from the last character.
Returns
A substring of a specific length.
*
*
*
Example
The following example displays the last four characters of each value in the ProductCode field:
RIGHT([ProductCode], 4)
The following example uses RIGHT( ) in conjunction with the LEN( ) and FIND( ) functions to display the characters that appear after the hyphen in a product code. This example assumes that the number of characters after the hyphen varies. Therefore, the length of the entire string (returned by LEN( )) minus the length up to the hyphen (returned by FIND( )) is the number of characters to display.
RIGHT([ProductCode], LEN([ProductCode]) - FIND("-" , [ProductCode]))
If the product code is ModelA-Ford, the expression returns Ford. If the product code is ModelCZ15-Toyota, the expression returns Toyota.

Additional Links:

Copyright Actuate Corporation 2012