On this page

    Categories: String


    Removes trailing spaces or characters from a string.


    RTRIM(expression varchar, trim_expression varchar) → varchar

    • expression: The expression to be trimmed.
    • trim_expression: Trailing characters to trim. If this parameter is not specified, then spaces will be trimmed from the input expression.


    RTRIM example
    SELECT RTRIM('pancake', 'cake')
    -- pan
    RTRIM example
    SELECT RTRIM('pancake pan', 'abnp')
    -- pancake
    RTRIM example
    SELECT RTRIM('dremio   ')
    -- dremio