RTRIM()

All functions > STRING > RTRIM()

Returns the string with whitespace from the right (end) removed.

Signatures

Returns: String with trailing whitespace removed

RTRIM(string: VARCHAR) → VARCHAR

Notes

• Removes trailing whitespace only (spaces, tabs, line breaks, and similar)
• Leading and internal whitespace are unchanged
• RTRIM('') is ''; if the input is NULL the result is NULL (use NULL(VARCHAR); bare NULL fails inference)

Examples

SELECT
    f1 := RTRIM('  hello  '), -- Trim right only
    f2 := RTRIM('  world	'), -- Trim tab from right
    f3 := RTRIM('  mixed   spaces  '), -- Only right trim
    f4 := RTRIM('no trim needed'), -- No right whitespace
    f5 := RTRIM(NULL(VARCHAR)) -- NULL yields NULL
;