Using the Empty String

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.