SET ANSI_NULLS ON;
-- Query1
SELECT 'ABCMudassar' AS Statement1
WHERE 'Mudassar' IN ('A','B', 'C', 'Mudassar', NULL);
-- Query 2
SET ANSI_NULLS Off;
SELECT 'ABCMudassar' AS Statement2
WHERE 'Mudassar' not IN ('A','B', 'C', NULL)
Differnce B/w SetAnsi_Nulls Off/On
In Query 2 if we switch to on the query doesn't work
why its happing