title: CASE IN statement with multiple values
body: <p>Is there a way to make a CASE statement with an IN clause?</p>
  
  <pre><code>SELECT
  CASE c.Number
  IN ('1121231','31242323') THEN 1
  IN ('234523','2342423') THEN 2
  END AS Test
  FROM tblClient c
  </code></pre>