Re: how can you count up the number of columns in a row that have a certain value

try this:

select count(*)
from table
where length(decode(read1,0,0,null)||

                          decode(read2,0,0,null)||


                           .


                           .


                           decode(read24,0,0,null)) > 16;