Strictly saying: it's impossible to use comparison operators, like:
<
,
>
or
=
.
Have a look here:
NULL Comparison Search Conditions[
^]
To use comparison operators with
NULL
, use
COALESCE[
^] function, which evaluates NULL values with other.
Sample 1
SELECT IntField
FROM TableName
WHERE COALESCE(IntField, 0) = 0
Sample 2
SELECT StringField
FROM TableName
WHERE COALESCE(StringField, '') = ''