title: How do you test inequality with Oracle Case Statement
body: <p>This works fine:</p>
  
  <pre><code>    select 
        case (1+2) -- (or_some_more_complicated_formula_yielding_a_numeric_result)
          when 200 then '200'
          when 100 then '100'
          else          'other'
        end hi_med_low
      from dual  ;
  </code></pre>
  
  <p>But I need to do something more like this:</p>
  
  <pre><code>    select 
        case (1+2) -- (or_some_more_complicated_formula_yielding_a_numeric_result)
          when greater than 200 then 'high'
          when less than    100 then 'low'
          else                       'medium'
        end hi_med_low
      from dual ;
  </code></pre>
  
  <p>Suggestions?</p>