Category: ASE: Functions: String Functions

rtrim()

The string function rtrim() removes all trailing blanks from a string.

Syntax of the String Function rtrim()

    rtrim ( char_expression | uchar_expression )
    

The parameters of the String Function rtrim()

"char_expression"
The parameter "char_expression" can be a column name, variable or constant and must be of one of the datatypes char, varchar, nchar or nvarchar. If the parameter "char_expression" has a value of NULL then the return value is also NULL.

"uchar_expression"
The parameter "uchar_expression" can be a column name, variable or constant and must be of one of the datatypes unichar or univarchar. If the parameter "uchar_expression" has a value of NULL then the return value will also be NULL.

Example for the String Function rtrim()

    select rtrim(sybase "   &nbsp " )

    go

    -----

    sybase
    

See also:

ASE T-SQL - Aggregate Functions,
ascii(),
char(),
char(n),
charindex(),
char_length(),
compare(),
difference(),
lower(),
ltrim(),
patindex(),
replicate(),
reverse(),
right(),
sortkey(),
soundex(),
space(),
str(),
String Functions,
stuff(),
substring(),
to_unichar(),
uhighsurr(),
ulowsurr(),
upper(),
uscalar().