RTRIM

Introduced or updated: v1.2.694

Removes all occurrences of any character present in the specified trim string from the right side of the string.

See also:

• TRIM_TRAILING
• LTRIM

Syntax

RTRIM(<string>, <trim_string>)

Examples

SELECT RTRIM('databendxx', 'x'), RTRIM('databendxx', 'xy');

┌──────────────────────────────────────────────────────┐
│ rtrim('databendxx', 'x') │ rtrim('databendxx', 'xy') │
├──────────────────────────┼───────────────────────────┤
│ databend                 │ databend                  │
└──────────────────────────────────────────────────────┘