Rick Debay wrote:

> Anyone? ASCII_VAL() shows the data ends with spaces, yet RTRIM() isn't removing them.

Make sure data is VARCHAR and not CHAR since char is padded with spaces.
If you have char column use cast(... as varchar(xxx)) to convert before
trimming.


--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org