How can I check for a numeric column for empty values

I want something like this:

select * from table where column_numeric = ''

This does not works obviously, but what can be the equivalent of this for numeric column?

1 Answer 1


A numeric column without a value is null:

select * 
from the_table
where column_numeric is null;

There is no equivalent concept of an "empty string" for numbers.

  • Actually, one could argue that the value 0 is the equivalent of an empty string. An empty string and null are not the same, unless you’re using Oracle. Nov 1, 2018 at 10:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.