Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer SQL Server Migration overview.

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