RE: [PHP-WIN] Nulls in database
| From: | Svensson, B.A.T. | Date: | Thu, 01 Feb 2001 18:15:22 +0000 |
| Subject: | RE: [PHP-WIN] Nulls in database | ||
| Groups: | php.general php.windows | ||
| Request: | Send a blank email to php-windows+get-5322@lists.php.net to get a copy of this message | ||
>I am trying to write a query to bring back rows that have null
>values set in them.
Try write
WHERE [Start Construction Date] IS NULL
OR [Actual Completion Date] IS NULL
or alternatively selecting both nulls and empty
attributes with or without white spaces:
WHERE isnull([Actual Completion Date], '') = ''
OR isnull([Start Construction Date]. '') = ''