Home Forums Article Discussions Article Discussions by Author Discuss content posted by lloyd monteiro Values <> null RE: Values <> null
deepak.a
SSCertifiable
Points: 5330
More actions
May 10, 2010 at 2:08 am
#1164872
The Result depends on set option
SET ANSI_NULLS OFF
select * from ##TableNulls where col2 <> null -- This will give Result
SET ANSI_NULLS ON
select * from ##TableNulls where col2 <> null -- this will not give result