Removes trailing spaces or characters from a string.


RTRIM(expression varchar, trim_expression varchar) → varchar

  • expression: The expression to be trimmed.

  • trim_expression: Trailing characters to trim. If this parameter is not specified, then spaces will be trimmed from the input expression.


RTRIM example
SELECT RTRIM('pancake', 'cake')
-- pan
RTRIM example
SELECT RTRIM('pancake pan', 'abnp')
-- pancake
RTRIM example
SELECT RTRIM('spice   ')
-- spice

Last updated