Edit a ntext <Long Text> field/record in a table. easily!
Posted on 2004-04-22
I have taken over a SQL 2000 database and within it is a table which has
content for ASP web pages.
Some of the content is pretty long, and for some reason is displayed as
<Long Text> in the table, up returning all rows.
This particular field is ntext.
I need to change this text, how can i do this by ammending the existing
text? I need to see what is there!
I have tried to look into this and there is no "simple" way to do this!!!
HELP!, and be gentle, i am new to SQL and need to be spoon fed a tad ;-)
Hope you guys can help,