//dr is datareader
if ( dr is DBNull )
//Handle null here
CASE WHEN dateSubmitted IS NULL THEN 'NOT YET SUBMITTED'
ELSE 'ALREADY SUBMITTED' END 'STATUS'
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)