Returns the rightmost specified number of bytes from the string. If the string is a binary string, the result is a binary string, and each character is one byte. If the string is a character string, the result is a character string, and each character is one byte. If the string is a graphic string, the result is a graphic string, and each character is a DBCS or UCS-2 character.
Example:
Assume that host variable ALPHA has a value of 'ABCDEF'.
SELECT RIGHT(:ALPHA,3) FROM T1
Returns the value 'DEF'.