How to use Not WildMatch function that should include Null values

[Cherry08]

Hi All,

I am trying to write a query that needs to eliminate couple of values(ID's) from a field(EmployeeID) so I am using Not WildMatch function as below 

Where Not WildMatch (EmployeeID,'22156', '22160','22340', '*23*');

But that function is also eliminating Null values in the EmployeeID field. Could someone help me how we can eliminate those ID's but include Null values?

Thanks

[Vegar · Accepted solution]

What about adding a condition for the null values like this

Where (
   isnull(EmployeeID) OR Not WildMatch (EmployeeID,'22156', '22160','22340', '*23*')
   );

[Saravanan_Desingh]

Try like this,

Where Not WildMatch (If(IsNull(EmployeeID),'ITSNULL',EmployeeID),'22156', '22160','22340', '*23*');

[Cherry08]

Thank You So much!! This works 😀

[Cherry08]

Thank You for your response!!