Empty Strings

An 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 statement is stored as “abc def”:

"abc" + "" + "def"

An empty string is never evaluated as NULL.