Re: [sqlite] Queries against NULL data

[Kareem Badr]

That seems to work perfectly.

How is the performance, comapared to changing the queries to check for 
NULL explicitly?
I usually use the coalesce() function to fix this.  For
example:
   SELECT * FROm table WHERE coalesce(test_field,'') != 'test value';

The "coalesce(test_field,'')" will convert all NULL values of
test_field to an empty string and leave all other values unchanged.