On 3/22/2012 11:32 AM, Fabio Spadaro wrote:
If I want to run a query like "select * from tablename where field1 = Null"

select * from tablename where field1 is null;

NULL is never equal any value, not even another NULL.
--
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to