Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Removes trailing blanks from the string.
RTRIM( string-expression )
The string to be trimmed.
The actual length of the result is the length of the expression minus the number of characters removed. If all the characters
are removed, the result is an empty string.
If the argument is null, the result is the null value.
The TRIM specifications defined by the SQL/2008 standard (LEADING and TRAILING) are supplied by the SQL Anywhere LTRIM and
RTRIM functions respectively.
The following statement returns the string Test Message, with all trailing blanks removed.
SELECT RTRIM( 'Test Message ' );