title: Using a conditional UPDATE statement in SQL
body: <p>I would like to have an <code>UPDATE</code> statement like this:</p>
  <pre><code> SELECT *
   FROM Employee
   WHERE age = CASE 
   WHEN (age &lt; 20) THEN age=15
   WHEN (age &gt; 20) THEN age= 20
  </code></pre>
  <p>Is this not possible in SQL Server / MySQL? I do not want to use the <em>stored procedures</em> or other things.</p>
  <p>Suggest me a suitable way around this problem.</p>