On 22 Mar 2012, at 3:41pm, Igor Tandetnik <itandet...@mvps.org> wrote:
> 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. So experiment with SELECT * FROM tablename WHERE typeof(field1) = "null" ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
