search and delete text

[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

 

[Ken Snell [MVP]]

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*";

 

[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*";

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

gls858