RIGHT can be used as a string function or in a join clause.

Returns the right part of a character string with the specified number of characters.

Syntax:

    RIGHT(character_expression, integer_expression)

Example:

SELECT RIGHT('abcdefg',2);-- Returns 'fg'

Syntax:

SELECT ...FROM table1RIGHT JOIN table2

See also:JOIN,LEFT