RIGHT

Syntax

RIGHT(char_expr, int_expr)

RIGHT returns int_expr rightmost characters of char_expr.

Example

This example returns the five rightmost characters of each author's first name.

SELECT RIGHT(au_fname, 5)
FROM AUTHORS

Here is the result set:
_________________

lbert
Ann
Anne
chael
ichel

Equivalents in other databases

TABLE 68. Equivalents in other databases

Oracle	SUBSTR function
Microsoft SQL Server	RIGHT function