Query to search for "includes"

[Susan]

I am trying to run a query for all fields that "include" a search term.

What criteria would I need to run?

Thank you!

 

[Jerry Whittle]

Like *The Search Term*

 

[Susan]

Thanks Jerry. Can I assume not like *search term* will search for do not
include?

 

[Pieter Wijnen]

Select ... From MyTable
WHERE MyField Like '*The Term to Find*'

HTH

Pieter

 

[Susan]

One more question...how do I say, if I am searching in field 1 like *search
term*, = field 2, if field 2 like *search term*, = field 3...

does that make sense?

 

[KARL DEWEY]

No, explain a little more. Give examples of what you mean.

 

[Susan]

For example, I am searching a mass mailing list for bad addresses. There are
three different mailing types, business, alternate, and home.

I would like to run a search stating, "if business mailing field includes
"bad address", replace it with alternate business address field. If
alternate business address field includes "bad address", replace it with
home. And if home address field includes "bad address", make field blank.

 

[KARL DEWEY]

I ASSUME the "bad address" means that the field contains that exact phrase.

You do not want a search but an update query. You need to run the update on
the home address field first then work backwards to the business mailing
field. This is neccesary because if you go the other direction you could be
replacing "bad address" with "bad address."