On 3/22/2012 12:18 PM, Jean-Denis MUYS wrote:
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
I did show this very example, except lacking the whitespace in front and
differing in capitalization. I assume you feel those distinct
characteristics render your example more interesting than mine.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users