SQLite 3 reference · String Functions

SQLite RTRIM() Function

Remove spaces, or characters you list, from the end (right side) of a string only.

SQLite 3

Create a free account to save this page, take notes and track your progress. Sign in

Syntax

rtrim(X, Y)

Parameter	Description
`X`	The string (other values are converted to text).
`Y` optional	The characters to remove; spaces by default.

The string without trailing characters.

Trailing spacesTry it yourself

SELECT '[' || rtrim('right   ') || ']' AS result;

Output

result
[right]

Trailing slashesTry it yourself

SELECT rtrim('https://example.com///', '/') AS url;

Output

url
https://example.com

TRIM() · Remove spaces, or any characters you list, from both ends of a string. Spaces inside the string are kept.
LTRIM() · Remove spaces, or characters you list, from the start (left side) of a string only.
SQL String Functions · tutorial