Chapter 2: Queries: Selecting Data from a Table

Concatenating strings and NULL

If you concatenate a string and NULL, the expression evaluates to the string. For example:

select "abc" + NULL + "def"

-----
abcdef