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