The empty string (“ ”or ‘ ’) is always stored as a single space in variables and column data. This concatenation statement is equivalent to “abc def”, not to “abcdef”:
"abc" + "" + "def"
The empty string is never evaluated as NULL.
Copyright © 2005. Sybase Inc. All rights reserved. |