Selection of blank, empty, null cells

[ennrike]

Hello,
I have a C# windows application that access to a data base and make some queries using OleDbDataAdapter

I would like to SELECT all entries that have empty, blank or null cells in the table:

SELECT * FROM MYTABLE where DATACOLUMN = null

I have already tried '' and null but it does not work.

What should I use to select the data that I want?

Thanks,

 

[Brianwarnock]

Where Datacolumn Is Null or Datacolumn =" " or Datacolumn =""
should cover all possibilities.

Brian