ASA SQL Reference
SQL Functions
Alphabetical list of functions
Returns the rightmost characters of a string.
RIGHT ( string-expression, integer-expression )
string-expression The string to be left-truncated.
integer-expression The number of characters at the end of the string to return.
If the string contains multi-byte characters, and the proper collation is being used, the number of bytes returned may be greater than the specified number of characters.
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Compatible with Adaptive Server Enterprise.
International Languages and Character Sets
The following statement returns the value olate.
SELECT RIGHT( 'chocolate', 5 )