Avatar of Becky Edwards
Becky Edwards
Flag for United States of America

asked on 

Dealing with NuLL Values returns no data

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) 

Open in new window

it doesn't return anyone because the patients currently have all NULL values in that field.

1      Anonymous
2      Confidential
3      Employee
4      Dismissed
5      Verified with no Medicare
6      Prisoner
7      VIP

How can I write my filter to account for the NULL value?
Microsoft SQL ServerSQL

Avatar of undefined
Last Comment
Megan Brooks

8/22/2022 - Mon