Chapter 15: Using the Built-In Functions in Queries

Concatenation and the empty string

Adaptive Server evaluates the empty string (“ ” or ‘ ’) as a single space. This statement:

select "abc" + "" + "def"

produces:

abc def