{"id":1047,"date":"2016-05-20T14:14:44","date_gmt":"2016-05-20T07:14:44","guid":{"rendered":"http:\/\/www.sqlitetutorial.net\/?page_id=1047"},"modified":"2024-04-30T19:14:17","modified_gmt":"2024-04-30T12:14:17","slug":"sqlite-rtrim","status":"publish","type":"page","link":"https:\/\/www.sqlitetutorial.net\/sqlite-functions\/sqlite-rtrim\/","title":{"rendered":"SQLite rtrim() function"},"content":{"rendered":"\n

SQLite rtrim()<\/code> function removes trailing spaces or specified characters from a string. It returns a new copy of the input string with the trailing characters removed.<\/p>\n\n\n\n

Syntax<\/h2>\n\n\n
rtrim(string,[character])<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Arguments<\/h2>\n\n\n\n
The rtrim()<\/code> function accepts two arguments:<\/p>\n\n\n\n
string<\/em><\/p>\n\n\n\n
The input string that you want to remove the characters.<\/p>\n\n\n\n
character<\/em><\/p>\n\n\n\n
The character string that you want to remove from the input string. It is optional. <\/p>\n\n\n\n
If you don’t specify it, it is assumed to be a space character and the \u00a0rtrim()<\/code> function will remove all trailing space from the input string.<\/p>\n\n\n\n
If you explicitly specify the characters you want to remove, the rtrim()<\/code> function will remove all the specified characters at the end of the string.<\/p>\n\n\n\n
Return Type<\/h2>\n\n\n\n
TEXT<\/p>\n\n\n\n
Examples<\/h2>\n\n\n\n
The following statement uses the rtrim()<\/code> function to remove trailing spaces from a string:<\/p>\n\n\n
SELECT<\/span> rtrim<\/span>('SQLite   '<\/span>) result<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
result\n------\nSQLite<\/code><\/span><\/pre>\n\n\n
The following statement uses the rtrim()<\/code> function to the USD from an amount:<\/p>\n\n\n
SELECT<\/span> rtrim<\/span>('500USD'<\/span>, 'USD'<\/span>) amount;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
amount\n------\n500<\/code><\/span><\/pre>\n\n\n
See Also<\/h2>\n\n\n\n
trim<\/a>, ltrim<\/a><\/p>\n
\n\t
\n\t\t
Was this tutorial helpful ?<\/div>\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
\n\t\t
\n\t\t\t
<\/div>\n\t\t\t\n\t\t\t