SQL: How do I replace NULL ( empty ) with zero in a sql query. For instance:

[kbdb]

My VBA recordset can't handle empty tables so I want to solve the problem by conding my SQL queery differently:

I have an sql querie:
Select top 1 variable1 from table1
where variable1 = X.

X is a certain value. The queerie is returning a table only with one column with one observation namely X.
If 'variable1' does not have any value equal X then the qurie will return an empty table. If that occur; How do I then make my table return 0 instead?

[AB33]

If 0 is a value number, try
where variable1 IS NOT NULL