423,851 Members | 2,762 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,851 IT Pros & Developers. It's quick & easy.

SELECT Query Looking for Date Fields That Contain No Date (blank)

P: n/a
I'm trying to do a SELECT statement looking for a DATE_COMPLETED field which
is blank, meaning it has not been completed. The DATE_COMPLETED field is a
DATE type field. How do I specify my WHERE conditiion to restrict the
results to only those records which have no DATE_COMPLETED data in them?

Thanks in advance,

Rick
Jul 31 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

Rick wrote:
I'm trying to do a SELECT statement looking for a DATE_COMPLETED field which
is blank, meaning it has not been completed. The DATE_COMPLETED field is a
DATE type field. How do I specify my WHERE conditiion to restrict the
results to only those records which have no DATE_COMPLETED data in them?

Thanks in advance,

Rick
SELECT ...
FROM MyTable
WHERE DATE_Completed IS NULL;

Jul 31 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.