On 22 March, Jean-Denis wrote:
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
(I doubt Igor felt damaged or slighted. Shame is hardly due. He was
just having some gentle fun.)
I just wanted to chime in with appreciation for Igor's contributions,
especially that he often *does* answer the question not asked when that
is more germane than simply answering the OP's question. I often find
his replies instructive.
--
Larry Brasfield
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
