Hardy,
Have you tried (it's worked OK for me in the past):

insert into internalTable (col1, col2, ...) select cast(field1 as varchar(222)),
cast(field2 as varchar(333)), ... from externalTable

Ciao,
John

> -------Original Message-------
> From: Hardy Sherwood <HardyS@...>
> Subject: RE: [firebird-support] RTRIM Overhead
> Sent: 16 Oct '07 04:58
>
> Sean,
>
> 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 declared the rtrim function with the statement
>
> declare external function rtrim cstring(32767) returns cstring(32767)
> free_it entry_point 'IB_UDF_rtrim' module_name 'ib_udf'
>
> Thanks,
>
> Hardy
>
> -----Original Message-----
> From: [LINK: mailto:firebird-support%40yahoogroups.com]
> firebird-support@yahoogroups.com
> [mailto:[LINK: mailto:firebird-support%40yahoogroups.com]
> firebird-support@yahoogroups.com] On Behalf Of Leyne, Sean
> Sent: Monday, October 15, 2007 11:36 AM
> To: [LINK: mailto:firebird-support%40yahoogroups.com]
> firebird-support@yahoogroups.com
> Subject: RE: [firebird-support] RTRIM Overhead
>
> > The run time before I added a call to RTRIM for each of the VARCHAR
>
> fields
>
> > was about 13 hours. After adding the call to RTRIM, but making no
>
> other
>
> > changes, the run time jumped to about 64 hours.
>
> How did you add the RTRIM call?
>
> Sean
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit [LINK: http://www.firebirdsql.org] http://www.firebirdsql.org and
> click the Resources item
>
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at [LINK: http://www.ibphoenix.com]
> http://www.ibphoenix.com
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
> [LINK: http://groups.yahoo.com/group/firebird-support/]
> http://groups.yahoo.com/group/firebird-support/
>
> Individual Email | Traditional
>
> [LINK: http://groups.yahoo.com/group/firebird-support/join]
> http://groups.yahoo.com/group/firebird-support/join
>
> (Yahoo! ID required)
>
> mailto:[LINK: mailto:firebird-support-digest%40yahoogroups.com]
> firebird-support-digest@yahoogroups.com
>
> mailto:[LINK: mailto:firebird-support-fullfeatured%40yahoogroups.com]
> firebird-support-fullfeatured@yahoogroups.com
>
> [LINK: mailto:firebird-support-unsubscribe%40yahoogroups.com]
> firebird-support-unsubscribe@yahoogroups.com
>
> [LINK: http://docs.yahoo.com/info/terms/]
> 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]
>
>