DataTable SELECT = Null

  • Thread starter Thread starter maflatoun
  • Start date Start date
M

maflatoun

Hi,

I have a datatable that I like to do a select on where col1='something'
and col2=empty but the following doesn't return anything even though I
know col2 is empty (length of data = 0). What am I doing wrong? Any
idea?

DataRow[] rows = ds.Tables["CurrentSessions"].Select("SessionID='" +
sessionID + "' AND SupportEmail = NULL");

Also tried SupportEmail = '', SupportEmail IS NULL. It works if I
remove SupportEmail condition.

Thanks
Maz
 
Back
Top