Copying rows with Long Datatypes

I am attempting to make a copy of a row with a Long/long raw datatype. I will change the primary key and one other field. All other columns remain the same including the Long/Long raw column. How do I do this since I can use something like

Insert into tablename
select column list
from table_name
where primary key = x
??

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 23 1999 - 09:38:44 CDT