Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.
Sign up to join this community
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?
Try:
"SPECIES" IS NOT NULL AND "SPECIES" != 'Corvus corax'
AND instead of the OR