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".

or

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.