RIGHT
Returns the right side of a string with the specified number of characters
Syntax
string RIGHT(string value, int num)
Example
RIGHT("Accounts", 3)
Will return "nts".
To get the last 4 letters of a product name from the ProductName column. In this example we will use the following two products "Data Synchronisation Studio" and "Ouvvi":
Right(ProductName, 4)
Will return "udio" for the product "Data Synchronisation Studio" and "uvvi" for the Ouvvi product.