Script - Not Match - Skips Null Values

[peterkumar]

Hello,

I am loading data which has null values for the CRITICALITY field.  

Null values are being skipped in the 'Not Match' function.

How do I include the null values and only skip 'C' and 'E' ?  - see below. 

Thanks,

Peter

Where
Not Match (CRITICALITY, 'C ', 'E')

[peterkumar]

Solved it by using 'Not Like' instead of Not Maatch

where

//Not Match (CRITICALITY,  'C ', 'E')

(Not CRITICALITY like 'C' and Not CRITICALITY like  'E')