Weird Problem with Null conditions in SQL 2000

• Jack Turnbull

  Grasshopper

  Points: 13

  More actions

  April 18, 2007 at 4:19 pm

  #68613

  I have a strange problem occurring in SQL 2000.  When running queries with a "Is Not Null" criteria, I get the correct results.  When running the same query with an "Is Null" criteria, I get data that is definitely not NULL!  I've never seen this before and need some help.  I've tried rebuilding indexes, no joy.  DBCC CheckTable and CheckDB routines turn up nothing.  What's going ON?

• Jason Selburg

  SSC-Insane

  Points: 24641

  More actions

  April 18, 2007 at 5:21 pm

  #701291

  Can you post the queries in question, table definition and some sample data/results? This would help a lot in solving this.

  ______________________________________________________________________

  Personal Motto: Why push the envelope when you can just open it?

  If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

  Jason L. Selburg