The RTRIM function removes specified characters from the right-hand side of a string.
RTRIM( string [, trim_string])
string :
• character string
• string valued column
• NULL
trim_string :
• character string
• NULL
SELECT RTRIM (' Olympic ');
rtrim(' Olympic ')
======================
' Olympic'
--If NULL is specified, it returns NULL
SELECT RTRIM ('iiiiiOlympiciiiii', NULL);
rtrim('iiiiiOlympiciiiii', null)
======================
NULL
-- trimming specific strings on the right
SELECT RTRIM ('iiiiiOlympiciiiii', 'i');
rtrim('iiiiiOlympiciiiii', 'i')
======================
'iiiiiOlympic'