you’re telling SQL to take a value and compare it against every value or set of values in a list using =. If any NULL values exist, a row will not be returned–even if both values are NULL.

In normal data storage (that is, NU not specified), a null value is represented by two bytes (one for the value length and one for the null value). Suppressing null values results in a null value ...