title: SQL use CASE statement in WHERE IN clause
body: <p>Is it posible to use <em>case</em> in <em>where in</em> clause?
  Something like this:</p>
  
  <pre><code> DECLARE @Status VARCHAR(50);
   SET @Status='published';
  
   SELECT * FROM Product P    
   WHERE P.Status IN (CASE WHEN @Status='published' THEN (1,3)
                                     WHEN @Status='standby' THEN (2,5,9,6)
                                     WHEN @Status='deleted' THEN (4,5,8,10)
                                     ELSE (1,3)
                                     END)
  </code></pre>
  
  <p>This code gives the error : <em>Incorrect syntax near ','.</em></p>