RTRIM( string-expression )

• VARCHAR
• NVARCHAR
• LONG VARCHAR
• LONG NVARCHAR

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.

This function supports NCHAR inputs and/or outputs.

• TRIM function [String]
• LTRIM function [String]
• String functions

The following statement returns the string Test Message, with all trailing blanks removed.

SELECT RTRIM( 'Test Message     ' );