Hi Claudio,

>
> SQL> insert into dest(d) select 'z'||substring(b from 1 for 30000) from b;
> SQL> select d from dest;
>

Yes, that's what I am trying to achieve. But what's the limitation of
substring? Is it 32,767 characters? My problem is that I don't know how much
data would be contained in that memo field, and wish to preserve all
possible characters.

Best regards,
jr