On 22 mars 2012, at 16:41, Igor Tandetnik 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.
> --
> Igor Tandetnik
>
Welcome to Igor's style. He never answers the question you don't ask :-)
I have come to learn and appreciate his socratic style. Thanks Igor.
In the meantime, you might be interested in something like
select * from tablename where field1 IS Null
Jean-Denis
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
