title: WHERE clause with nested multiple conditions
body: <p>I want to retrieve data with conditions in <code>WHERE</code> clause.<br>
  Here is my table something look like:</p>
  
  <pre><code>Name   Location    Age
  ----------------------
  AAA     Bhuj       24
  BBB     Mumbai     22
  CCC     Bhuj       18
  DDD     Bhuj       27
  EEE     Mumbai     26
  </code></pre>
  
  <p>My condition in <code>WHERE</code> clause is:<br>
  <code>if location = 'Bhuj' then Age&gt;20 else if location = 'Mumbai' then Age&gt;25</code></p>
  
  <p>I am trying this code to achieve this:</p>
  
  <pre><code>SELECT * FROM testing
  WHERE 
  CASE Location WHEN 'Bhuj' THEN Age&gt;20
                WHEN 'Mumbai' THEN Age&gt;25
  END;
  </code></pre>
  
  <p>This code works fine for MySQL (<a href="http://sqlfiddle.com/#!2/6120e/1">see this SQLFiddle</a>) but does not work for SQL Server (<a href="http://sqlfiddle.com/#!3/6120e/1">see this SQLFiddle</a>) and giving the following error:</p>
  
  <blockquote>
    <p>Incorrect syntax near '>'.: SELECT * FROM testing WHERE case Location When 'Bhuj' then Age>20 When 'Mumbai' then Age>25 end</p>
  </blockquote>
  
  <p>Any suggestion?</p>