SQLite Forum

Not Equal Operator
Login
Chronological Hierarchical 
NULL != 'any Value' evaluates to NULL
NULL == 'any Value' evaluates to NULL
NULL IS NOT 'any Value' evaluates to TRUE

you are looking for the expression

testColumn IS NOT 'testValue'

to correctly handle NULLs in testColumn