Text & patterns Scalar

rtrim()

Removes any occurrences of any of the characters from the right side of the string. characters defaults to space.

Arguments & returns

2 overloads

Scalar

Overload link	`string`	Returns
#01	`VARCHAR`	`VARCHAR`

Scalar

Overload link	`string`	`characters`	Returns
#02	`VARCHAR`	`VARCHAR`	`VARCHAR`

SELECT rtrim('    test  ');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT rtrim('>>>>test<<', '><');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT LTRIM(s), RTRIM(s), TRIM(s)

In DuckDB

SELECT LTRIM(s), RTRIM(s), TRIM(s)

SELECT BASE64_ENCODE(x, 76)

In DuckDB

SELECT RTRIM(REGEXP_REPLACE(TO_BASE64(x), '(.{76})', '\1' || CHR(10), 'g'), CHR(10))