Full text search and replace

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andy Gilman - 21 Jul 2004 06:31 GMT

Need to search through a database and remove references to a company from
it. Grrr!

How can I do this? Do I need to write a client script to load each offending
record, or can I do it with SQL?

Conceptually I want to do

REPLACE IN Resumes TEXT 'Company Name' WITH ''

This is a full text table.

whats the best approach?

Reply to this Message

Hilary Cotter - 21 Jul 2004 13:15 GMT

I'd try something like this:

declare @replacement varchar(200)
set @replacement='test'
update testtext
set textcol=
substring(textcol,1, patindex('%company%',textcol)-1)
+@replacement +
substring(textcol,patindex('%company%',textcol)+len('company'),datalength(te
xtcol)-patindex('%company%',textcol)+len('company'))
from testtext

Signature

Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html

> Need to search through a database and remove references to a company from
> it. Grrr!
[quoted text clipped - 9 lines]
>
> whats the best approach?

Reply to this Message