RTRIM

Introduced or updated: v1.2.659

Removes specific characters from the end (right side) of a string.

See also:

• TRIM_TRAILING
• LTRIM

Syntax

RTRIM(<string>, <trim_character>)

Examples

SELECT RTRIM('databendxx', 'xx');

┌───────────────────────────┐
│ rtrim('databendxx', 'xx') │
├───────────────────────────┤
│ databend                  │
└───────────────────────────┘