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.
Copyright © 2005. Sybase Inc. All rights reserved. |