insert/select LONG

NEVER SAY DIE!!! There has to be a way!

I have a table with a LONG field. The data for this table is in another table. I can't do:

insert into tableA (fld1, fld2, fld3long) select fldA, fldB, fldClong
from tableB;

So, how do I get long data from one table to another? I don't care if I have to stand on my tounge, there has to be a way to do this.

-- 
Richard Basile       <> Telxon Corporation      <> My opinions are my own.
rbasi_at_telxon.com     <> 3330 W Market St        <> They are free.
1-800-800-8001 x3868 <> Akron, Ohio  44334-0582 <> 100% money back guarantee.