Trims the specified expression of trailing blanks.
rtrim(char_expr | uchar_expr)
is a character-type column name, variable, or constant expression of char, varchar, nchar, or nvarchar type.
is a character-type column name, variable, or constant expression of unichar or univarchar type.
select rtrim("abcd ")
-------- abcd
rtrim, a string function, removes trailing blanks.
For Unicode, a blank is defined as the Unicode value U+0020.
If char_expr or uchar_expr is NULL, returns NULL.
Only values equivalent to the space character in the current character set are removed.
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute rtrim.
Documentation Transact-SQL Users Guide
Function ltrim
