When SET ANSI_NULLS is OFF, comparisons of all data against a null value evaluate to UNKNOWN if the data value is NULL

When SET ANSI_NULLS is OFF, comparisons of all data against a null value evaluate to UNKNOWN if the data value is NOT NULL

When SET ANSI_NULLS is OFF, comparisons of all data against a null value evaluate to FALSE if the data value is NULL

When SET ANSI_NULLS is OFF, comparisons of all data against a null value evaluate to TRUE if the data value is NULL