On 22 mars 2012, at 17:26, Igor Tandetnik wrote: > 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
Well, my apology. I didn't read your example carefully enough. Shame on me. Let me retract my answer (except my praise for your Socratic style, which I will not retract even if it doesn't quite apply here). Jean-Denis _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users