Records with null excluded when searching for does-not-equal 0

I have a table with the property 'status' that can be 0, 1 or null.

I want to pull all the records where status does not equal 0.

But it's only returning records where status=1. It doesn't include records where status=null.

Could that be tweaked to include records where the value is null so it's more intuitive?

[image.png]
[image.png]
Other
3 replies