title: CASE Statement in where clause using equal to and IN
body: <pre><code>WHERE CONDITION1='ABC'
  AND Status =
      CASE  @Option 
              WHEN 1 THEN 'True'
              WHEN 2 THEN 'False'
              WHEN 3 THEN  NULL
              WHEn 4 THEN **IN ('True', 'False', NULL)**
      END
  </code></pre>
  
  <p>How do I write a query where my first options match directly using <code>=</code>  but my last option needs an <code>IN</code></p>
  
  <p>The above query gives error, but I want something similar to it, which I am not able to find out.</p>