RTRIM

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

This function corresponds to the rtrim(X, Y) function in SQLite.

• If only one argument column is provided, it removes trailing spaces from the string.

• If the optional trimChars argument is provided, it removes any character present in trimChars from the end of the string in column.

If the input column is not a string, it is first coerced into one. A NULL input results in a NULL output.

Example

// Removes trailing spaces: rtrim('hello  ') -> 'hello'
select(RTRIM(StringLiteral("hello  "))).execute()

// Removes specified trailing characters: rtrim('hello--**', '*-') -> 'hello'
select(RTRIM(StringLiteral("hello--**"), "*-")).execute()

// Using a column
select(RTRIM(Users.username)).from(Users)

Parameters

See also