topic Re: How to use Not WildMatch function that should include Null values in App Development

How to use Not WildMatch function that should include Null values

Cherry08 — Tue, 24 Aug 2021 19:06:39 GMT

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

Re: How to use Not WildMatch function that should include Null values

Vegar — Tue, 24 Aug 2021 19:10:28 GMT

What about adding a condition for the null values like this

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

Re: How to use Not WildMatch function that should include Null values

Saravanan_Desingh — Tue, 24 Aug 2021 19:50:33 GMT

Try like this,

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

Re: How to use Not WildMatch function that should include Null values

Cherry08 — Tue, 24 Aug 2021 20:07:31 GMT

Thank You So much!! This works 😀

Re: How to use Not WildMatch function that should include Null values

Cherry08 — Tue, 24 Aug 2021 20:08:29 GMT

Thank You for your response!!