๊Update ntext With replace Function

UPDATE [db_name].[dbo].[db_table]
SET [column_name]= CAST(replace(CAST(column_name as NVarchar(MAX)),'text_original','text_toreplace') AS NText) WHERE [column_condition]= [condition_value]

Best Free Software For Your Personal Computer

Create PDF

PDFCreator
http://www.pdfforge.org/pdfcreator

Notepad (Alternative)

Notepad++
http://notepad-plus-plus.org

Download Manager

Free Download Manager
http://www.freedownloadmanager.org

Image Viewer

XNView
http://www.xnview.com
IRFANVIEW
http://www.irfanview.com/

You can suggest more. but for now this is all I try and work well With my Windows 8.1, Widows 7 and Windows Server 2012.