hello, I need to return results depending on a condition which a date field is greater (newer) than other date field. using this for example:

select * from mytable where mydate1>olddate2;

the problem is that all results are returned because olddate2 rows are all NULL because its constructed to accept null, and no date entered yet in that field. what is the solution?

Thank's