Sean,



I'm not sure which version, but its at least version 2.0. If you need a
more precise answer, I can get this information.



Hardy





-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Leyne, Sean
Sent: Monday, October 15, 2007 1:25 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] RTRIM Overhead



Hardy,

> To add the rtrim function I revised the statement

>

> insert into internalTable (col1, col2, ...) select field1, field2, ...

> from externalTable

>

> to

>

> insert into internalTable (col1, col2, ...) select rtrim(field1),

> rtrim(field2), ... from externalTable

>

> for those columns which are defined as varchar in the internal table.

I should have asked this last time... what version of FB are you

running?





Sean





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



Visit http://www.firebirdsql.org 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



http://groups.yahoo.com/group/firebird-support/



Individual Email | Traditional



http://groups.yahoo.com/group/firebird-support/join

(Yahoo! ID required)



mailto:firebird-support-digest@yahoogroups.com

mailto:firebird-support-fullfeatured@yahoogroups.com



firebird-support-unsubscribe@yahoogroups.com



http://docs.yahoo.com/info/terms/




-----------------------------------------------------------------------------------
This message and contents are confidential and intended solely for
the use of the individual or entity to whom they are addressed. If you
have received this email in error please notify the system manager.

The original email message has been scanned for computer viruses.
-----------------------------------------------------------------------------------



[Non-text portions of this message have been removed]