Ispirer SQLWays Database Migration Software

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 79. Equivalents in other databases

Oracle	SUBSTR function
Microsoft SQL Server	RIGHT function

             

Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.