title: T-Sql: Case Expression with Mutliple condition
body: <p>Currently i have this statement and is bringing me correct results</p>
  
  <pre><code>select 
      case column1
          when 'G07' then 'G15'
          when 'G09' then 'G15'
          when 'G15' then 'G15'
      end
      as Code 
  from tableX
  </code></pre>
  
  <p>The problem with the above is that i have bunch of cases to write for each column, so I'm after something more compact like the following but unfortunately do not compile :</p>
  
  <pre><code>select 
      case column1
          when 'G07','G09','G15' then 'G15'
      end
      as agente   
  from tableX
  </code></pre>
  
  <p>Any thought? Thanx</p>