On 6 Jun 2011, at 3:02am, Sidney Cadot wrote: > Hi Jay, > >> As others have pointed out, one of the meanings of NULL is essentially >> "unknown." > > Yes, but in terms of IEEE-754, there exist no "unknown" results
Jay is talking about SQL. SQL /does/ use NULL for 'unknown'. And the OP was trying to match values with NULL. And was using a SQL command to do it. So the matching will be done using SQL semantics. See this page for the result: http://www.sqlite.org/nulls.html If you want to explicitly test for NULL, use the function typeof(). Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users