Not Like

[Sonic_Extreme]

I have a owner column with thousands of different names. I want to separate business to individuals. I am trying to create something to exclude these words from the Owner Column. *llc*, *inc*, *health*, *trust*, *holding*, *estate*, *hotel*, *corp*, *music*, *center*, *associ*, *med*, *ltd*, *est*, *invest*, *mortg*, *relations*, *prod*, *org*, *llp*, *savings*, *law*, *finance*, *engineer*, *construc*, *bank*, *marketing*, *disability*, *international*, *communi*, *skin*, *county*. what can I do to exclude these words all on one query.





Thank you for your help.

[Gicu]

I would add them to a table with an Exclude field (so you can easily maintain that list), bring that to the query and use InStr([Owner],[Exclude])=0 as the criteria.
Cheers,

[orange]

See this tutorial from Bob Larson for an approach.

[Micron]

Can any Owner records be Null? If so, IIRC Instr will return null so I would not think that = 0 would work for those records. Might need to wrap in Nz function?
Nz(InStr([Owner],[Exclude]),0)=0