I want to filter out patients who have a 1, or a 2 in the following field, leaving patients who either have a NULL value or any of the other values.
When I put in this filter
pt.PATIENT_TYPE_C not in (1,2)
it doesn't return anyone because the patients currently have all NULL values in that field.
5 Verified with no Medicare
How can I write my filter to account for the NULL value?