Comment by magicalhippo

> Also a null is no equal to anything.

Wrong. It is equal to UNKNOWN:

https://docs.microsoft.com/en-us/sql/t-sql/queries/is-null-t...