Subject RE: [firebird-support] LTRIM and RTRIM failures
Author Rick Debay
Table DDL shows the field as VARCHAR.

-----Original Message-----
[] On Behalf Of Milan Babuskov
Sent: Thursday, May 11, 2006 4:00 PM
Subject: Re: [firebird-support] LTRIM and RTRIM failures

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


Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at


Yahoo! Groups Links