Returns the specified expression, trimmed 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.
For general information about string functions, see “String functions”.
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute rtrim.
Function ltrim
Copyright © 2005. Sybase Inc. All rights reserved. |