title: SQL query I need to populate 1 return value from possible values in 3 columns
body: <p>I need query to return one value based on possible values in 3 different columns.  Only 1 of the 3 columns will be greater than 0. I'm having problems creating the query.</p>
  
  <p>Table:</p>
  
  <pre><code>FIELDA    FIELDB    FIELDC   FIELDD    FIELDE 
  ---------------------------------------------
  Plastic   Blue      0        10        0 
  Plastic   Blue      10       0         0 
  Plastic   Blue      0        0         20
  </code></pre>
  
  <p>Query something like:</p>
  
  <pre><code>select 
      FieldA, FieldB,
      (If FieldC &gt; 0 then 'We Have C'
      else if FieldD &gt; 0 then 'We Have D'
      else if FieldE &gt; 0 then 'We Have E'
      end if
      ) as WeHave
  from 
      ThingsWeHave
  </code></pre>
  
  <p>I would like return results to be.</p>
  
  <pre><code>FieldA     FieldB     WeHave
  ---------------------------------
  Plastic    Blue       We Have D
  Plastic    Blue       We Have C   
  Plastic    Blue       We Have E
  </code></pre>