Re: using empty date field in query

If the date is null it is not used with operators(=,<,> ..) (in fact the use of an operator prevents the return of any Null column.

So you should try something like

SELECT COUNT(0) FROM prop_date where p_date is null.

Regards, Received on Wed Mar 22 2006 - 06:50:55 CST