I tried to filter my spatialite layer with the

"SPECIES" IS NOT NULL OR "SPECIES" != 'Corvus corax'

expression, but the result contains the lines where "FAJ" field is 'Corvus corax' (the NULL value withered correctly).

What's wrong with this expression? How can I filter all of the rows where "SPECIES" field is not null or not equal to Corvus corax?

1 Answer 1



   "SPECIES" IS NOT NULL AND "SPECIES" != 'Corvus corax'

AND instead of the OR


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.