Try: [Start Construction Date] is null
or: [Start Construction Date] is not null
~~LF
"Conover, Ryan" wrote:
> I am trying to write a query to bring back rows that have null values set in
> them. I cannot figure out how to do this. I can bring back all rows that do
> not have nulls with the following query.
>
> SELECT [ID], [Project Name], [Start Construction Date], [Actual Completion
> Date]
> FROM common WHERE [Start Construction Date] != ' ' OR [Actual Completion
> Date] != ' '
>
> I tried changing the != to = but it does not return anything.
>
> I am running these queries off a MSSQL 7.0 Server
>
> Ryan
>
> --
> 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]
--
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]
