Query on null date

[seb2]

Having problems with SQL for pulling all records where 'completed_date' NOT NULL.

Select*
from table
where table.complete_date = NOT NULL;

or
where table.complete_date = '';

Neither seems to work. What am I missing?

 

[carrr]

Try running your first query without the = in front of NOT NULL

 

[sunaj]

Hi,

try:

Select * from MyTable where NOT table.complete_date IS NULL;

ps.
I just tested your other question about BETWEEN. It works for me:

Select * from tblstation where not [datetime] between '01/01/97' AND '01/01/02'


Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'

 

[tlbroadbent]

The proper syntax for checking NULLs is ...

IS NULL or IS NOT NULL Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[carrr]

tlbroadbent is right on with the IS NOT NULL.
My apologies.

 

[seb2]

Thanks everyone!!!!