RIGHT
This function will return a number of characters from the right hand end of a string.
RIGHT( <field_name or string> , LENGTH )
-
field name or string: The field or string value to use.
Example: create a field at the CUSTOMER level that returns the last 3 characters of their surname.
RIGHT([CUSTOMER.SURNAME],3)