>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 General 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]
