{"id":1198,"date":"2019-02-17T15:51:04","date_gmt":"2019-02-17T08:51:04","guid":{"rendered":"http:\/\/www.sqlservertutorial.net\/?page_id=1198"},"modified":"2020-04-11T20:12:53","modified_gmt":"2020-04-11T13:12:53","slug":"sql-server-rtrim-function","status":"publish","type":"page","link":"https:\/\/www.sqlservertutorial.net\/sql-server-string-functions\/sql-server-rtrim-function\/","title":{"rendered":"SQL Server RTRIM Function"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the SQL Server RTRIM()<\/code> function to truncate all trailing blanks from a string.<\/p>\n\n\n\n

SQL Server RTRIM() function overview #<\/a><\/h2>\n\n\n\n

The RTRIM()<\/code> function returns a string after truncating all trailing blanks. The following is the syntax of the RTRIM()<\/code> function:<\/p>\n\n\n

RTRIM(input_string)\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax, the input_string<\/code> is an expression of character or binary data. It can be a literal string, variable, or column.<\/p>\n\n\n\n
SQL Server RTRIM() function examples #<\/a><\/h2>\n\n\n\n
Let’s take some examples of using the RTRIM()<\/code> function.<\/p>\n\n\n\n
A) Using RTRIM() function with literal strings #<\/a><\/h3>\n\n\n\n
This example uses the RTRIM()<\/code> function to truncate trailing blanks of the string 'SQL Server RTRIM function '<\/code>:<\/p>\n\n\n
SELECT<\/span> \n    RTRIM<\/span>('SQL Server RTRIM Function   '<\/span>) result<\/span>;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Here is the output:<\/p>\n\n\n\n
result\n----------------------------\nSQL Server RTRIM Function\n\n(1 row affected)\n<\/code><\/pre>\n\n\n\n
B) Using RTRIM() function to clean up blanks in tables #<\/a><\/h3>\n\n\n\n
Suppose you want to remove trailing blanks in one or more column of a table. To do this, to do this you can use the following UPDATE statement:<\/p>\n\n\n
UPDATE<\/span> \n    table_name\nSET<\/span> \n    column_name = RTRIM<\/span>(column_name);\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
For example, to remove all trailing blanks of the values in the first_name<\/code> column in the sales.customers<\/code> table, you use the following statement:<\/p>\n\n\n
UPDATE<\/span> \n    sales.customers\nSET<\/span> \n    first_name = RTRIM<\/span>(first_name);\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this tutorial, you have learned how to use the SQL Server RTRIM()<\/code> function to remove the trailing blanks from a string.<\/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
The input_string<\/code> must evaluate to a value of a data type, except for TEXT<\/code>, NTEXT<\/code> and IMAGE<\/code>, that can be implicitly convertible to VARCHAR<\/a><\/code>. Otherwise, you must use the CAST()<\/code> function to convert it to a character string explicitly.<\/p>\n\n\n\n