Deleting from Memo fields?

[George Bowyer]

I have a contacts database where each contact has a memo field in which I record details of letters ent, phone calls made etc in this format:

# 01/02/05 Letter sent re XYZ
# 28/01/5 Telephoned at 13.26 re ABC
# 15/01/05 Letter sent re PQR

etc.

Every now and then, I mailshot selected contacts and put a standard memo note in for each one saying that they had that particular letter or whatever.

Is it possible to use a routine (or query) to search through the contacts table and delete a particular string from the memo fields of all contacts in which it can be found?

I've been puzzling at this one for a long while, and the inspiration is just not hitting me...

Thanks,

George

 

[Bat17]

I think that you should be able to do it using the replace function.
Replace("YourMemo","Text to Delete","").
Make sure you test this out on a copy of the DB first though! just in case there are any unforseen events like truncating the memo field to 255 chars!

Peter