Concatenate Strings and NULL

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

For example:
select "abc" + NULL + "def"
-----
abcdef
Parent topic: “Unknown” Values: NULL