Is your SQL drawing a blank? It’s NULL a surprise! The title of this post is a play on words, but very appropriate. We are going to discuss the inconsistent results, as well as performance ...

SQL intentionally differentiates NULL from all other values. NULL is not an integer or text or anything else (though it does carry type information). In fact, NULL is literally equal to nothing else.