Skip to main content
Version: 24.3.x

Categories: String

RTRIM

Removes trailing spaces or characters from a string.

Syntax

RTRIM(expression varchar [, trim_expression varchar]) → varchar

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

Examples

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