thanks for the reply.... but i got this error

Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'from'.


the problem may that description is a ntest column

when i run this query ......

update item set description=(select description from item where itemid=5384);

i get this error message...

Msg 279, Level 16, State 3, Line 1
The text, ntext,...

i have a column "discription" in my item table that is full of HTML code. It was created using and editor like the one i am using here. It is five pages long when i print it out.

I need to ...