Progress
SQL-92
Guide and Reference
RIGHT Function
Returns the rightmost count of characters of string_exp.
SYNTAX
EXAMPLE
This example illustrates the RIGHT function, selecting the rightmost six letters from the string ’Afghanistan’:
NOTES
- The
string_exp
can be fixed-length or variable-length CHARACTER data types.- The
count
can be INTEGER, SMALLINT, or TINYINT data types.- If any of the arguments of the expression evaluate to null, the result is null.
- If
count
is negative, the result evaluates to null.string_exp
and the result may contain multi-byte characters.count
represents the number of characters.COMPATIBILITY
ODBC Compatible
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |