RTRIM function
The RTRIM function trims a specified set of characters from the end of a string. Removes the longest string containing only characters in the trim characters list. Trimming is complete when a trim character does not appear in the input string.
Syntax
RTRIM( string, trim_chars )
Arguments
- string
-
A string column, expression, or string literal to be trimmed.
- trim_chars
-
A string column, expression, or string literal that represents the characters to be trimmed from the end of string. If not specified, a space is used as the trim character.
Return type
A string that is the same data type as the string argument.
Example
The following example trims leading and trailing blanks from the string '
abc ':
select ' abc ' as untrim, rtrim(' abc ') as trim;untrim | trim ----------+------ abc | abc
The following example removes the trailing 'xyz' strings
from the string 'xyzaxyzbxyzcxyz'.
The trailing occurrences of 'xyz' are removed,
but occurrences that are internal within the string are not removed.
select 'xyzaxyzbxyzcxyz' as untrim, rtrim('xyzaxyzbxyzcxyz', 'xyz') as trim;untrim | trim -----------------+----------- xyzaxyzbxyzcxyz | xyzaxyzbxyzc
The following example removes the trailing parts
from the string 'setuphistorycassettes' that match any of the characters in the trim_chars list 'tes'.
Any t, e, or s that occur before another character that is not in the trim_chars list at the ending of the input string are removed.
SELECT rtrim('setuphistorycassettes', 'tes');rtrim ----------------- setuphistoryca
The following example trims the characters 'Park' from the end of VENUENAME where present:
select venueid, venuename, rtrim(venuename, 'Park') from venue order by 1, 2, 3 limit 10;venueid | venuename | rtrim --------+----------------------------+------------------------- 1 | Toyota Park | Toyota 2 | Columbus Crew Stadium | Columbus Crew Stadium 3 | RFK Stadium | RFK Stadium 4 | CommunityAmerica Ballpark | CommunityAmerica Ballp 5 | Gillette Stadium | Gillette Stadium 6 | New York Giants Stadium | New York Giants Stadium 7 | BMO Field | BMO Field 8 | The Home Depot Center | The Home Depot Cente 9 | Dick's Sporting Goods Park | Dick's Sporting Goods 10 | Pizza Hut Park | Pizza Hut
Note that RTRIM removes any of the characters P, a,
r, or k when they appear at the end of a VENUENAME.