InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 26 May 2013 02:29:18 GMT20http://www.sqlservercentral.com/Forums/Topic495406-1269-1.aspx[quote][b]Matt Miller (5/6/2008)[/b][hr]Hey - I think this is a DUMB question, and the author should get smacked around. I mean - sheesh....Oh wait - never mind...:D(thanks for the feedback guys!)[/quote]If this is a dump question, then we required lot more like this ....:cool:Tue, 06 May 2008 21:58:38 GMTAnipaulhttp://www.sqlservercentral.com/Forums/Topic495406-1269-1.aspxHey - I think this is a DUMB question, and the author should get smacked around. I mean - sheesh....Oh wait - never mind...:D(thanks for the feedback guys!)Tue, 06 May 2008 11:47:27 GMTMatt Miller (#4)http://www.sqlservercentral.com/Forums/Topic495406-1269-1.aspxGreat Question! I almost stumbeled...I only would have added this one as well:SET ANSI_NULLS OFFSELECT COUNT(ggg) FROM testnull WHERE ggg=1 OR ggg!=1 OR ggg=NULL;Tue, 06 May 2008 11:37:01 GMTChristian Buettner-167247http://www.sqlservercentral.com/Forums/Topic495406-1269-1.aspxI thought it would be 3,[b]3[/b],3,2,2 instead of the correct 3,[b]2[/b],3,2,2. That shows me that I understand NULL pretty well, just not ANSI_NULLS OFF. It's nice to know that it's going away, then. :)I've saved these queries for when I have to explain how NULL works to other people.Tue, 06 May 2008 11:18:41 GMTMichael Sallmenhttp://www.sqlservercentral.com/Forums/Topic495406-1269-1.aspxGreat question. I always had hard time reading value of NULL's. No wonder I got it wrong today.Tue, 06 May 2008 11:00:00 GMTSanjayAttrayhttp://www.sqlservercentral.com/Forums/Topic495406-1269-1.aspxThe last 3-4 questions are really good. The quality of questions have improved. We should applaud the team. :)Tue, 06 May 2008 09:38:04 GMTAnipaulhttp://www.sqlservercentral.com/Forums/Topic495406-1269-1.aspxI agree. I think this is a great question. I got it wrong, but it showed me I still have more to learn about NULLs.Thanks,webrunnerTue, 06 May 2008 07:43:27 GMTwebrunnerhttp://www.sqlservercentral.com/Forums/Topic495406-1269-1.aspxGood question. Actually made me turn my brain on and think, and no "how many months have 28 days in them" type tricks.Tue, 06 May 2008 06:45:42 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic495406-1269-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/TSQL/62732/">ANSI_NULLS</A>[/B]Tue, 06 May 2008 00:10:07 GMTMatt Miller (#4)