RIGHT

Keyword RIGHT

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

String Function

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'

RIGHT JOIN

Syntax:

    SELECT ... FROM table1 RIGHT JOIN table2

See also: JOIN, LEFT