DB \ SQL --- Concate Null String w/ String

When SET CONCAT_NULL_YIELDS_NULL is ON
Concatenating a null value with a string yields a NULL result.
SELECT 'abc' + NULL ==> NULL

When SET CONCAT_NULL_YIELDS_NULL is OFF
Concatenating a null value with a string yields the string itself
SELECT 'abc' + NULL ==> abc

Beware!