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

IBM DB2	RIGHT function
Oracle	SUBSTR 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.