TRIM_TRAILING

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

See also:

• RTRIM
• TRIM_LEADING

Syntax

TRIM_TRAILING(<string>, <trim_character>)

Examples

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

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