Adaptive Server evaluates the empty string (“ ” or ‘ ’) as a single space. This statement:
select "abc" + "" + "def"
produces:
abc def
