![REPLICATE function [String]](arrow-left.gif){kind=icon}
![ROUND function [Numeric]](arrow-right.gif){kind=icon}
Returns the rightmost characters of a string.
RIGHT ( string-expression, numeric-expression )
string-expression The string to be left-truncated.
numeric-expression The number of characters at the end of the string to return.
The following statement returns the value olate.
SELECT RIGHT( 'chocolate', 5 ) FROM iq_dummy
If the string contains multibyte characters, and the proper collation is being used, the number of bytes returned may be greater than the specified number of characters.
Chapter 11, “International Languages and Character Sets” in the Sybase IQ System Administration Guide
