How do I filter excluding more than 1 word 2

[Rmcta]

I need to have my query filter excluding sentences that contain "*TEAM", "TEAM*", "US"
I tried where FieldName NOT IN("*TEAM", "TEAM*", "US")
but it does not work.

What is the syntax?

 

[tracy1234]

I'm not sure if you can use the wildcards with NOT IN. Try this:

Where Fieldname Not Like "*TEAM" or Not Like "TEAM*" or Not Like "US"

-Tracy

 

[GoDawgs]

That needs to be "And"s, not "Or". Also you could combine your first two into Not like "*Team*"

Hope that helps.

Kevin

 

[Rmcta]

You are correct. Thank you very much!