The empty string (“”) or (‘’) is interpreted as a single blank in insert or assignment statements on varchar data. When varchar, char, nchar, or nvarchar data is concatenated, the empty string is interpreted as a single space. For example, this is stored as “abc def”:
"abc" + "" + "def"
The empty string is never evaluated as NULL.
