The RIGHT function returns the rightmost integer characters of expression.
If expression is a character string, the result is a character string, and each character is one byte. If expression is a graphic string, the result is a graphic string, and each character is a DBCS or Unicode graphic character. If expression is a binary string, the result is a binary string, and each character is one byte.
A substring of expression is zero or more contiguous characters of expression. If expression is a graphic string, a character is a DBCS or Unicode graphic character. If expression is a character string or binary string, a character is a byte.50
The expression is effectively padded on the right with the necessary number of blank characters (or hexadecimal zeroes for binary strings) so that the specified substring of expression always exists.
The result of the function is a varying-length string with a length attribute that is the same as the length attribute of expression and a data type that depends on the data type of expression:
Data type of expression | Data type of the Result |
---|---|
CHAR or VARCHAR | VARCHAR |
CLOB | CLOB |
GRAPHIC or VARGRAPHIC | VARGRAPHIC |
DBCLOB | DBCLOB |
BINARY or VARBINARY | VARBINARY |
BLOB | BLOB |
The actual length of the result is integer.
If any argument can be null, the result can be null; if any argument is null, the result is the null value.
The CCSID of the result is the same as that of expression.
SELECT RIGHT( :ALPHA, 3) FROM SYSIBM.SYSDUMMY1Returns the value 'DEF', which are the three rightmost characters in ALPHA.
SELECT RIGHT( 'ABCABC', 0) FROM SYSIBM.SYSDUMMY1
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.