Integer fields: treat zero 0 and empty NULL as different values in smart lists

[Anonymous]

When creating a Smart List that will look for all leads whose integer field is set to 0, we get all leads who not only have the value of 0 (zero), but we also get all leads whose value for that integer field is empty.

We would like this to be treated differently.
If we look for leads whose integer value is 0, then only give us leads whose value is 0 and not empty.

[Anonymous]

Casting my vote.

I strongly agree, in SQL zero is a well defined value while NULL is not zero.
NULL denotes a value has not been assigned yet, a placeholder for unknown or inapplicable values.