asi lo solucione: Código PHP:
set xact_abort on
begin tran
declare @otxt varchar(1000)
set @otxt = CHAR(11)
declare @ntxt varchar(1000)
set @ntxt = ''
declare @txtlen int
set @txtlen = len(@otxt)
declare @ptr binary(16)
declare @pos int
declare @id int
declare curs cursor local fast_forward
for
select
id_noticiA,
textptr(detalle),
charindex(@otxt, detalle)-1
from
noticias
where
detalle
like
'%' + @otxt +'%'
open curs
fetch next from curs into @id, @ptr, @pos
while @@fetch_status = 0
begin
print 'Text found in row id=' + cast(@id as varchar) + ' at pos=' + cast(@pos as varchar)
updatetext noticias .detalle @ptr @pos @txtlen @ntxt
fetch next from curs into @id, @ptr, @pos
end
close curs
deallocate curs
commit tran
Basandome en este articulo.
http://www.sqlteam.com/article/searc...-a-text-column
Lo publico aqui por si a alguien le sirve.
adios
