Table DDL shows the field as VARCHAR.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Milan Babuskov
Sent: Thursday, May 11, 2006 4:00 PM
To: firebird-support@yahoogroups.com
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
trimming.


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




++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links