title: Oracle check across multiple columns and return the first not 0.00
body: <p>I have three columns in my result set;</p>
  
  <pre><code>o.id    o.value_one    o.value_two    o.value_three
  ----    -----------    -----------    -------------
  1       1.00           0.00           0.00
  2       1.00           1.00           0.00
  3       1.00           1.00           1.00
  4       0.00           1.00           1.00
  5       0.00           0.00           1.00
  6       0.00           0.00           0.00
  </code></pre>
  
  <p>I want to compare all three value columns and return the value of the column where it is not 0.00.</p>
  
  <p>So I would return;</p>
  
  <pre><code>o.id    o.new_value
  ----    -----------
  1       1.00       
  2       1.00       
  3       1.00       
  4       1.00       
  5       1.00
  </code></pre>
  
  <p>Thanks for any help!
  Chris</p>