What it does
Checks for stringified NULL.
Why not?
NULL is not a data value, but a marker for an absent value, and it should not be
quoted.
Putting NULL in quotes makes it a string value, which is not the same as a NULL value.
When should you?
Never.
Use instead:
Use NULL without quotes.