RTRIM Function

Description

The RTRIM function removes specified characters from the right-hand side of a string.

Syntax

RTRIM( string [, trim_string])

 

string :

character string

string valued column

NULL

 

trim_string :

character string

NULL

Example

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'