Can I use NULL with the IN operator in SQL?

Описание: In SQL, can you use NULL in the list of items for an IN operator? The short answer is no, but why? I demonstrate that it doesn't work, then dig deeper into the query plans and talk about the IS comparison operator.