Instead of using the setting CONCAT_NULL_YIELDS_NULL = OFF, Isah will use the setting CONCAT_NULL_YIELDS_NULL = ON.

The setting CONCAT_NULL_YIELDS_NULL = OFF is declared deprecated by Microsoft.

You can only use features such as indexed views and filtered indexes if CONCAT_NULL_YIELDS_NULL = ON.

The CONCAT_NULL_YIELDS_NULL setting is a connection setting only.

When CONCAT_NULL_YIELDS_NULL = OFF, a NULL value in a string addition is treated as an empty string. If CONCAT_NULL_YIELDS_NULL = ON, if one of the arguments in a string addition is NULL, the result of the addition is NULL.