Just for my own record, dealing with Null type field. Checking with : select * from tablename where field1=”  -> this one not work select * from tablename where field1=’Null’ -> same too is null is the answer select * from tablename where field1 is null Save my day, thanks to St4r 🙂