Here was a useful article I found on how to do a find and replace on SQL Server Text fields: Microsoft SQL Server - Search and Replace in a TEXT column - SQLTeam.com:


Here is the useful bit of SQL in question:
"declare @otxt varchar(1000)
set @otxt = 'ExistingText'

declare curs cursor local fast_forward
for
select
id,
textptr(TargetField),
charindex(@otxt, TargetField)-1
from
TargetTable
where
TargetField
like
'%' + @otxt +'%'"

Then this other sql makes the change.

declare @otxt varchar(1000)
set @otxt = 'ExistingText'

declare curs cursor local fast_forward
for
select
id,
textptr(TargetField),
charindex(@otxt, TargetField)-1
from
TargetTable
where
TargetField
like
'%' + @otxt +'%'  ¶ 4:56 PM

  An interesting site with theory proposed by it's author for the explaination of everything Grand Unification & Time - Welcome  ¶ 1:03 PM