RTRIM

Returns a character string after truncating all trailing spaces.

Syntax

RTRIM ( character_expression )

Arguments

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.

Return types

varchar or nvarchar

Examples

SELECT RTRIM('Five spaces are at the end of this string.     ');

See Also