Claus,
I know nothing about Jaybird, but a bit about SQL:

SELECT * FROM TABLE1
WHERE MY_DATE IS NOT NULL AND NOT (MY_DATE = '09.04.1961')

I have never seen <> in SQL and doubt it is allowed.

HTH,
Set

At 12:12 10.01.2003 +0100, you wrote:

>Dear Guys
>I have problems to work with data in Jaybird- JDBC !
>Fiebird and WebObjects and Jaybird 1.3.1
>
>How to work something like that:
>
>select * from table1 where my_date <> "17.11.1858" (or null or a
>special date my birthday "09.04.1961" or other date)
>the same here "... where my_date <> '1858-11-17 00:00:00 +0000' ...