How to manage dates in Delphi/SQL

I have made an IntrBase Database in Delphi. I will list only the records where a datefield is empty. I have made the following command:
SELECT * FROM BOOKS
WHERE DATEFIELD <> ' '
but this don't work. What do I wrong?
sconesAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
RBertoraConnect With a Mentor Commented:
Hi there, I am unsure of what it is exactly that you want to do
but may I suggest this:

DateField is NULL
or DateField is not Null

Hope it is usefull..
Rob.
0
 
sconesAuthor Commented:
Thank you very much Rob for this info.
Anton
0
All Courses

From novice to tech pro — start learning today.