How to use REPLACE() within NTEXT columns in SQL Server
select cast(replace(cast(myntext as nvarchar(max)),'find','replace') as ntext)
from myntexttable
select cast(replace(cast(myntext as nvarchar(max)),'find','replace') as ntext)
from myntexttable