Home Library Learn Downloads Support Community
Sign in | United States - English | |
5 out of 9 rated this helpful - Rate this topic

RTRIM (Transact-SQL)

SQL Server 2008

Returns a character string after truncating all trailing blanks.

Topic link iconTransact-SQL Syntax Conventions

Copy 

RTRIM (character_expression )
character_expression

Is an expression of character data. character_expression can be a constant, variable, or column of either character or binary data.

character_expression must be of a data type that is implicitly convertible to varchar. Otherwise, use CAST to explicitly convert character_expression.

varchar or nvarchar

Compatibility levels can affect return values. For more information, see sp_dbcmptlevel (Transact-SQL).

The following example demonstrates how to use RTRIM to remove trailing spaces from a character variable.

Copy 
DECLARE @string_to_trim varchar(60);
SET @string_to_trim = 'Four spaces are after the period in this sentence.    ';
SELECT @string_to_trim + ' Next string.';
SELECT RTRIM(@string_to_trim) + ' Next string.';
GO

Here is the result set.

-------------------------------------------------------------------------

Four spaces are after the period in this sentence. Next string.

(1 row(s) affected)

-------------------------------------------------------------------------

Four spaces are after the period in this sentence. Next string.

(1 row(s) affected)

Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ
RTRIM does not trim CHAR(160)
Important - LTRIM and RTRIM only remove the space character CHAR(32). They do not remove a CHAR(160) which is a non-breaking space . The strings rtrim('12345' + char(160)) and rtrim('12345' + char(32)) are not the same.
History
Mistake of the Result set

The first row of the result set should have 4 spaces before 'Next string' because the first SELECT didn't use RTRIM()

History