hello

i need to populate my datagrid view with records from my database.
the records i require are the ones that have not yet been closed so i wish to search for all records where there is no date in the closed column.

im not sure how to write my sql, i tried.....
select * from table where closed = ""

i just get a syntax error

i looked on the net but couldnt find any examples of searching by a blank date!

Thanks,

Iain