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”: