NULL Compared to the Empty String

The empty string (“ ”or ‘ ’) is always stored as a single space in variables and column data.

This concatenation statement is equivalent to “abc def”, not to “abcdef”:
"abc" + "" + "def"

The empty string is never evaluated as NULL.

Parent topic: Using Nulls in Expressions