RTRIM (Transact-SQL)
Returns a character string after truncating all trailing blanks.
Transact-SQL Syntax Conventions
- 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.
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.
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)
Reference
CAST and CONVERT (Transact-SQL)Data Types (Transact-SQL)
String Functions (Transact-SQL)
