nico_callewaert@... wrote:

> Problem is : the IS NOT NULL part is working well, but IS NULL part doesn't retrieve any records. I checked in the DB and the values are set to NULL.
> Is there a better syntax for EMPTY dates ?

Which version of Firebird (Interbase). It works fine for me.
Have you tried using IS NULL in IB_SQL?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services