title: Does Informix support CASE statement inside a SELECT query
body: <p>I am using the SELECT query below, and it isn't working if I give CASE statements. Can anyone please advise me if Informix allows CASE, or if statements in a select query or if there is any other alternative to what I am trying below?</p>
  
  <pre><code>select a.post_date, a.count_date,
      case 
          when (a.tover&gt;b.sun_num) then a.tover 
          else '0' 
      end case as t_over,
      case 
          when (a.tshort&gt;b.sun_num) then a.tover 
          else '0' 
      end case as t_short,
  from a join b on a.cust_ix = b.cust_ix
  </code></pre>
  
  <p>I have tried replacing '0' with 0 and null, no luck.</p>