When SET CONCAT_NULL_YIELDS_NULL is ON, concatenating a null value with a string yields a NULL result.
For example,

SELECT ‘abc’ + NULL == NULL.

When SET CONCAT_NULL_YIELDS_NULL is OFF, concatenating a null value with a string yields the string itself (the null value is treated as an empty string).
For example,

SELECT ‘abc’ + NULL == abc.

Tags:

Related Entries