>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]. '') = ''
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]