title: SQL Server: CASE statement in WHERE clause with IN condition
body: <p>I would like to use, in a stored procedure with @input as input value, a case statement in a where clause like this :</p>
  
  <pre><code>SELECT my_column
  FROM MY_TABLE
  WHERE MY_TABLE.my_column in (CASE WHEN @input = '1' THEN ('A','B','C') ELSE ('A') END)
  </code></pre>
  
  <p>Incredibly, it works when I place only one value after "THEN" like this :</p>
  
  <pre><code>SELECT my_column
  FROM MY_TABLE
  WHERE MY_TABLE.my_column in (CASE WHEN @input = '1' THEN ('C') ELSE ('A') END)
  </code></pre>
  
  <p>Can I use the <code>IN</code> condition with a <code>CASE</code> statement like I wanted above? Is there an another way to do what I want ?</p>
  
  <p>Thank you for your help,</p>
  
  <p>CLJ</p>