>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 Comple
as saying if [Start Construction Date] is not equal to ' '
(space character).
In SQL the not equal to comparison "!=" is actually "<>".
-Toby
- Original Message -
From: "Richard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thur
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
I don't know ANYTHING about ANY of this stuff...but where I come from (C)
you would use 2 equal signs (==) to match values. Dunno if that applies
here, but usually when you use 1 equal sign, you are assigning values.
Rick
-Original Message-
From: Conover, Ryan [mailto:[EMAIL PROTECTED]]
