search and delete text

  • Thread starter Thread starter gls858
  • Start date Start date
G

gls858

I have a memo field that contains the same phrase in every record.

Is there any way other than editing each record to get rid of the phase.

gls858
 
You can run an update query (make a copy of the database file first!):

UPDATE YourTableName
SET MemoFieldName = Replace(MemoFieldName, "That Pesky Phrase", "")
WHERE MemoFieldName Like "*That Pesky Phrase*";
 
Ken said:
You can run an update query (make a copy of the database file first!):

UPDATE YourTableName
SET MemoFieldName = Replace(MemoFieldName, "That Pesky Phrase", "")
WHERE MemoFieldName Like "*That Pesky Phrase*";
Click to expand...

Thanks Ken that did the trick. I appreciate the help.

gls858
 
Back
Top