RIGHT function [String]

RIGHT( string-expression, integer-expression )

string-expression The string to return the rightmost characters for.
integer-expression The number of characters at the end of the string to return.

LONG VARCHAR

If the string contains multibyte characters, the number of bytes returned may be greater than the specified number of characters.

You can specify an integer-expression that is larger than the value in the column. In this case, the entire value is returned.

Whenever possible, if the input string uses character-length semantics, the return value is described in character-length semantics.

The following statement returns the last 5 characters of each Surname value in the Customers table:

SELECT RIGHT( Surname, 5 ) FROM GROUPO.Customers;