find&replace type of query?

[555466]

How is it possible to make an UpdateQuery, which would go through all the
records in certain Table, in certain Field and for example find all the
g-letters and replace them with w-letter. I know, how to do it with the
whole information on Fields (for example Criteria="XYZ" Update to"ZYX", but
how to go through and change some of the letters in fields ?

Field Criteria="a" Update to "E"
-------
Jack JEck
Jan JEn
Jill Jill
Jim Jim
Jordan JordEn
Andrew Andrew

 

[[MVP] S. Clark]

See the Replace() Function.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[555466]

Any chance you could give me an example ? And to be honest, I am not a
coder-type of guy, so if there is some hands-on straight forward example,
that would be excellent...