>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 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 [St
ECTED]]
Sent: Thursday, February 01, 2001 12:05 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-WIN] Nulls in database
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
