RIGHT

version 11

RIGHT (arithmetic_expression, arithmetic_expression)

The RIGHT function returns the rightmost part of the arithmetic_expression passed. The second arithmetic_expression indicates the number of rightmost characters to return as extracted from the first arithmetic_expression indicated.

This example returns the first names and the last two letters of the last names from the PEOPLE table:

   SELECT FirstName, RIGHT(LastName, 2) 
   FROM PEOPLE;

LEFT.