Including NULL in WHERE clause

Question

How do include "IS NULL" in my WHERE clause along with a list of characters.

So for example, the following fields should be include in the WHERE clause

NULL
Arts
Science

Currently im doing a UNION ALL, firstly getting all the NULLs and then all those with a normal character like Arts and Science

Answer 1

try this way :

select * from 
tablename where field is NULL OR field IN ('arts','science')

---

Please vote if you find this posting was helpful or Mark it as answered.

Answer 2

ive tried that initially and it doesn't pick up the NULLs with characters

Answer 3

You may try below if NULL is character NULL as well:

select * from
tablename where field is NULL OR field IN ('arts','science','NULL')

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.