Really wish that SQL supported the concept of “we know there isn’t a value here” in addition the the idea of “we don’t know what the value is”. Unfortunately, it only properly supports the latter, which is why NULL = NULL is false.

*****
Written on