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 “abcdef”:
"abc" + "" + "def"
The empty string is never evaluated as NULL.
