Instead of using the WRITETEXT statement to update a text or image field, you can use the UPDATETEXT statement. UPDATETEXT is more flexible than WRITETEXT, because it changes only a portion of a text or image value in place (WRITETEXT updates and replaces an entire text or image field).
For details on UPDATETEXT, see the UPDATETEXT statement in the Microsoft SQL Server Transact-SQL Reference.