Selecting Null field from database.

• lparks2001

  Old Hand

  Points: 328

  More actions

  January 17, 2003 at 6:57 am

  #79443

  Hello everyone, very easy question. How to i write a sql statement to choose a <NULL> value from the database i tried this and it did not result in anything..

  MY Query = SELECT * FROM Categories

  WHERE Parent_ID = 0

  Can anyone help me?

• Antares686

  SSC Guru

  Points: 125444

  More actions

  January 17, 2003 at 7:01 am

  #446613

  Use

  WHERE Parnet_ID IS NULL

  Check out this article for a bit of info on how IS NULL works

  http://www.sqlservercentral.com/columnists/jtravis/understandingthedifferencebetweenisnull.asp

• lparks2001

  Old Hand

  Points: 328

  More actions

  January 17, 2003 at 7:07 am

  #446616

  Thanks Antares686. I'm going to bookmark this page. I'm reading up on it now. Very good information. Thanks allot it worked.