i have feedback table with column comments1(varchar) & comments(ntext) ..i tried to copy the content from column Comments to another comments1 column,It shows the follwing error..
My Query is ,
" update feedback set comments1=comments "
Disallowed implicit conversion from data type ntext to data type varchar, table 'Test.dbo.feedback', column 'comments1'.
Use the CONVERT function to run this query.
update feedback set comments1=cast(varchar(yourLength of the varchar),comments)
Don't forget to click "Mark as Answer" on the post that helped you.
Yeah..Its working now..Thanks for ur kind help...