using empty date field in query

Hi all.

I am trying to build a query that can update empty date-fields in my db-table.

I have no problem retrieving entires where date field is not empty, with the following query:

     select count(*) from prop_date where p_date > '06-02-01' This returns '6', which is all fine and dandy, but the revering the comparator

     select count(*) from prop_date where p_date > '06-02-01' returns '0', whereas i would expect something like '121512', since my table has 121518 entries.

My bet would be that there is a real simple explanation, I just can't figure it out ;-)

Thanx in advance
Dortique Received on Wed Mar 22 2006 - 05:15:17 CST