sql server unable to evaluate null

• dreaddan

  Valued Member

  Points: 57

  More actions

  March 25, 2003 at 5:37 am

  #159687

  Hi, we've encounterd a odd problem.

  SQL server isnt able to evaluate NULL's properly.

  It has been working fine, but today it's properly gone down the pan.

  If I run these querys

  select count(*) from message

  select count(*) from message where id is null

  select count(*) from message where id is not null

  select count(*) from message where isnull(id,0x0)=0x0

  I get

  20939148

  20914216

  16956682

  3982466

  the third and forth querys equal the first but the second isnt the same as the forth..

  Does any one have any ideas?

  dan

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  March 25, 2003 at 6:31 am

  #452027

  Please continue discussion in duplicate thread where answers exist: http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=10830&FORUM_ID=9&CAT_ID=1&Topic_Title=sql+server+unable+to+evaluate+null&Forum_Title=General

  --

  Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

  http://www.sql.nu

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/