The statement<BR><BR>select * from emp where resigndate is null <BR><BR>does not bring any record although there are number of records.<BR><BR>What's wrong?<BR><BR>TIA<BR>RAJ.
are they really null? you know the difference between a null and an empty string, right?
Execute this SQL as a Query in Access on the database itself.<BR><BR>Do you get any results? If not, are you sure that there are records that have that column as null?<BR><BR>Craig.
many people don't.<BR><BR>in addition to previous suggestions, run this :<BR><BR>select * from [emp] where IsNull([resigndate]) = true