looking for nulls

Results 1 to 2 of 2

Thread: looking for nulls

  1. #1
    Join Date
    Dec 1969

    Default looking for nulls

    I&#039;m running this sql statement against a db table in SQL Server 2000:<BR> <BR>SELECT *<BR>FROM tblCategories<BR>WHERE (ParentUUID = NULL)<BR> <BR>ParentUUID is a uniqueidentifier field which allows nulls. There are several records in the table where the value of ParentUUID is null. When I run this sql statement, I get no records returned. I don&#039;t understand why I&#039;m getting no records back when I know there are records in the table with ParentUUID = NULL. Any suggestions?<BR> <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: looking for nulls

    ISNULL() should work.<BR>http://www.sqlteam.com/item.asp?ItemID=510<BR>~~Chaotix

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts