If you concatenate a string and NULL, the expression evaluates to the string. For example:
select "abc" + NULL + "def"
----- abcdef
