Syntax
RTRIM(Argument)
Description
The RTRIM SQL scalar function removes blanks or hexadecimal zeroes from the end of a string argument.
The argument must be a string.
The length attribute of the result is the same as the length attribute of Argument. The actual length of the result is the length of the argument minus the number of bytes removed.
If all characters are removed, the result is an empty string.
If the first argument can be null, the result can be null; if the first argument is null, the result is the null value.
Example
Assume the column HELLO of type CHAR(9) has a value of 'Hello '.
RTRIM(HELLO)
Results in: 'Hello'.
List of SQL scalar functions by topic