title: How to filter data of CASE WHEN statement using where condition?
body: <p>After allies CASE WHEN condition as column can we filter that column?</p>
  
  <p>Example;</p>
  
  <pre><code>SELECT 
      CASE WHEN Number like '20%' THEN 'X'
     WHEN Number like '15%' or  Number like '16%'  THEN 'Y' ELSE 'Z'
     END Operation
     ,*
  FROM 
  TableA
  where Operation like 'X'
  </code></pre>
  
  <p>I called CASE WHEN condition as 'Operation' and now I want to see only the Operation 'X' in the Operation column.</p>
  
  <p>Is there a way to filter CASE WHEN condition with where clause in SSMS 2012?</p>