Return columns which has NULL or 0 Values in a row

Question

I've a Table with 10 fields. Each field or column contains Integer values.

Now I need only field(s) to be returned which has Null or 0 in the result set.

Answer 1

This worked for me. For instance:

Instead of:

where column_name is null or column_name = 0

It would be:

where COALESCE(column_name,0) = 0

Posted by Jon Gabrielson on December 18, 2002

The function 'COALESCE' can simplify working with null values. for example, to treat null as zero, you can use: select COALESCE(colname,0) from table where COALESCE(colname,0) > 1;