You can, of course, use user-defined functions (aka UDFs) in Queries, just
as you can use the built-in Replace function in Access 2000 and later
versions. There is an implementation of replacing a string within a string
at
http://www.mvps.org/access/strings/str0004.htm. The title indicates that
it is for replacing a character, but, in fact, it replaces a string of
whatever length you desire. If that doesn't work for you, using Google
Groups to search the archives should turn up many implementations of Replace
functions that people used prior to the Replace built-in function being
available in Access 2000.
Just for the record,
http://www.mvps.org/access does not have everything
about Access, but it is a more-than-reasonable place to start looking,
because it has so much that is so useful.
Larry Linson
Microsoft Office Access MVP
"MLH" <CR**@NorthState.netwrote in message
news:qk********************************@4ax.com...
>I have memo field containing imported data.
In it are numerous Chr(13) & Chr(13) & Chr$(10)
occurrences. How do I rid my table of all occurrences
of this 3-character string ?
Generally there is only a single occurrence in
the memo field of any record.