title: SQL return multiple values from CASE statement
body: <p>How do I rewrite this SQL statement to do what I need?</p>
  
  <pre><code> SELECT * FROM TABLE 
      WHERE COLUMN_NAME_1 IN (CASE 
          WHEN COLUMN_NAME_2 = 'X' THEN 'A' 
          WHEN COLUMN_NAME_2 = 'Y' THEN 'B', 'C' END)
  </code></pre>
  
  <p>Obviously I can't return multiple values from a CASE clause... so how else could I write this? I am pretty sure I am slow today because this seems so easy ....</p>