Convert LONG to a VARCHAR2

I don't suppose there is a way to convert a LONG to a VARCHAR2.

I'm trying to insert a values larger than 32K into a LONG (possible?). I'm trying to be clever and say something like:

update table set col1 = CONCAT( col1, <large value> )

where col1 and <large value> are each smaller than 32k, but together are

larger thank 32k.

Thanks,

Chris

--
Chris Forlano
Automation Development
Nortel Networks, Maidenhead
590 4342 (01628 434 342)
cforlano_at_nortelnetworks.com Received on Mon Oct 04 1999 - 04:32:17 CDT