title: using sets in a case end command
body: <p>I have a table T with a field called county. I want to do something like</p>
  
  <pre><code>select (CASE
                WHEN T.county IN ('Ana', 'Beba', 'Ceca') THEN 'Rural'
                WHEN T.county IN ('Bob', 'Mob', 'Cob') THEN 'Urban'
          END) 'County Group'
  </code></pre>
  
  <p>the possible values for county are 'Ana', 'Beba', 'Ceca', 'Bob', 'Mob', 'Cob'</p>
  
  <p>how can this be done? I am trying to use ('Ana', 'Beba', 'Ceca') and ('Bob', 'Mob', 'Cob') as sets</p>
  
  <p>Thanks
  Jose</p>