• if you use IS NULL then there will not be any effect on the ANSI_NULLS settings