Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
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?
A numeric column without a value is null:
where column_numeric is null;
There is no equivalent concept of an "empty string" for numbers.
Required, but never shown