SQl query or function

[ashley12]

Hi to all,

I have a table consisting of 12 columns of data type number. for each row i want to display a count wherever the value of a row is greater than 100, that is, how many times the value greater than 100 appear in the 12 columns.
PLease help???

Thanks

 

[Mile-O]

Why do you have 12 columns set up in this way. This makes me suspicious as to the structure of your database. It doesn't sound as if you have normalised it.