title: TSQL case statement with multiple when values?
body: <p>Is there a way to do something like this? (This is pseudo code)</p>
  
  <pre><code>      CASE(@P1) 
          WHEN 'a' or 'd' or 'z' THEN 1
          WHEN 'b' or 't' THEN 2
          ELSE 0 
  </code></pre>
  
  <p>The idea being that I can check multiple values that should return the same value. i.e. 'a' returns 1 and 't' returns 2</p>