RTRIM

Removes blanks or hexadecimal zeroes from the end of a string expression. The argument must be a string expression.

Example:

Assume column HELLO has a value of 'Hello '.

   RTRIM(HELLO)

Results in: 'Hello'.