Progress
SQL-92
Guide and Reference


RIGHT Function

Returns the rightmost count of characters of string_exp.

SYNTAX

RIGHT ( string_exp , count ) 

EXAMPLE

This example illustrates the RIGHT function, selecting the rightmost six letters from the string ’Afghanistan’:

SELECT RIGHT(fld1,6) FROM  test100 WHERE fld1 = ’Afghanistan’;
 
RIGHT(FLD1,6)               
---------------
nistan                   
 
1 record selected 

NOTES

COMPATIBILITY

ODBC Compatible


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095