2

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?

3

Try:

   "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, privacy policy and cookie policy

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