I want to do a sql that search when a field is null....<BR>How to i search for null field?<BR>e.g. <BR>select * from [Table] Where [ATTEND] = '" Null "'"
You may try to user<BR><BR>select * from [Table] Where [ATTEND] IS Null<BR><BR><BR>Steven
Irene,<BR><BR>Have you tried.<BR><BR>SELECT value1, value2 FROM tblName WHERE Value IS NULL?<BR><BR>Not sure if it will work, but I know IS NULL will return all null values :)
Select * from tablename where fieldname is NULL;