How to combine values into one so that there is 1 exclusion that covers both values?

[verifi81]

Howdy folks

This is my field:

ABC_Account_Name

I want to exclude these values:

mcas*
gmcas*

I know I can do it this way:

ABC_Account_Name!=mcas ABC_Account_Name!=gmcas

how do I combine them into one so that I have 1 exclusion that covers both values?

[SanjayReddy · Accepted solution]

Hi @verifi81 

please try this

NOT ABC_Account_Name IN  ("mcas*" ,"gmcas*")

---
If this reply helps you, an upvote/Karma would be appreciated.