Like or contains

[amerifax]

It seems that Like is the same as contain. I know id I do a query that is as following:
Field: PredominateUse
Table: 2010Master
Like "*Single*"
I will get every record that contains the word "Single" as long as it appears in the Field: PredominateUse.

But what if I wanted to match any word in field "Lot" & "NewLot" that contains.
Example:
"Lot" "NewLot"
Car Cars - (Match)
Ca Air - (No Match)
Blue Blue - (Match)
Air Air Plane - (Match)
Under the above I would want all records displayed that had Car, Blue, Air

Thanks Bob

 

[Galaxiom]

You should normalize these Uses and represent them as an ID number. Then you can search for the specific IDs. If you group the uses in a sensible numbering system you could search for ranges.

If there are multiple primary uses then use a join table to keep them as separate records.