PHWinfo - Afficher un message - what occurs in a comparison when a value is NULL

19/03/2008, 00h34

Well thanks for all the comments on the poor form of the SQL I have
come upon

Actually the subject was about comparing null values to those of a
data type, in this case INTEGER... I managed to find the answer via a
couple of SQL queries:

SELECT
case when NULL<>0 then 0
else 666
end

SELECT
case when NULL=0 then 0
else 666
end

and because the Number of the Beast is the result in both cases, we
see that NULL is neither equal to a number nor not equal to it... now
I can solve my problem.

Thanks dudes.

19/03/2008, 00h34	#4
metaperl Messages: n/a Hébergeur:	Re: what occurs in a comparison when a value is NULL Well thanks for all the comments on the poor form of the SQL I have come upon Actually the subject was about comparing null values to those of a data type, in this case INTEGER... I managed to find the answer via a couple of SQL queries: SELECT case when NULL<>0 then 0 else 666 end SELECT case when NULL=0 then 0 else 666 end and because the Number of the Beast is the result in both cases, we see that NULL is neither equal to a number nor not equal to it... now I can solve my problem. Thanks dudes.