Returns the rightmost characters of a string.
Parameter |
Description |
---|---|
string-expression |
The string to be left-truncated. |
numeric-expression |
The number of characters at the end of the string to return. |
LONG VARCHAR
LONG NVARCHAR
The result data type is a LONG VARCHAR. If you use RIGHT in a SELECT INTO statement, you must have an Unstructured Data Analytics Option license or use CAST and set RIGHT to the correct data type and size.
The following statement returns the value “olate:”
SELECT RIGHT( 'chocolate', 5 ) FROM iq_dummy