I searched the prior posts and scrutinized the BOL ... I still have some confusion.
I am stuck with a database application that uses SS2k (no way of upgrading). A table the application uses has a field that is NVARCHAR(4000) ... stores non-Latin character sets ... that needs to be changed to NTEXT in order to store more character data. I understand my choices are UPDATETEXT and WRITETEXT.
Q1: If I am completely replacing the contents of one field in one row, do I use UPDATETEXT or WRITETEXT?
Q2: I am not having much luck getting UPDATETEXT to completely remove the old text and replace it with the new. Could someone show me the correct way to "replace all existing" text in the one field in the one row?
Thanks ahead of time for any help you can provide!