The empty string
"") or (
is interpreted as a single blank in insert or assignment
statements on varchar or univarchar data.
In concatenation of varchar, char, nchar, nvarchar data,
the empty string is interpreted as a single space; for following
example is stored as “abc def”:
"abc" + "" + "def"
The empty string is never evaluated as NULL.