RE: find and replace situation

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks a bunch, Karl!

"KARL DEWEY" wrote:

Use "George Fox" as criteria. Do not use the Like function and then it must
match exactly.
--
KARL DEWEY
Build a little - Test a little


"JWCrosby" wrote:

I have a text field for college names. Unfortunately, our data entry people
have been inconsistent in how they enter school names, making select queries
a bit problematic. For instance, "George Fox University" may have been
entered as
George Fox University, or
George Fox, or
George Fox U.

I want to make them all consistent, so all the appropriate records have
"George Fox University." I know I can do a find and replace on the "U." and
change it to "University", but how do I add "University" to the field that
only has "George Fox" in it? If I find "George Fox" and replace it with
"George Fox University" won't it create a "George Fox University University"
if the original field had "George Fox University" in it?

So, what I'm asking is how do I query to find those records that have
"George Fox" and "George Fox" only in that field?

Thanks in advance.

Jerry
.