> If I change IS NOT FALSE to IS TRUE, the results will be different. I > assume they should perform in the same way? > if you say "NULL IS NOT FALSE" is always true, then 'NULL IS TRUE' should > also be always true.
"NULL IS NOT FALSE" is true because NULL is not a value therefor it is not FALSE, because FALSE is a value. "NULL IS TRUE" is false because NULL is not a value so it's not TRUE. You can't compare NULL with anything. All you can do is tell if it "IS NULL" or "IS NOT NULL". _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users