Subject Re: [firebird-support] LTRIM and RTRIM failures
Author Milan Babuskov
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

Milan Babuskov