title: T-SQL: Using a CASE in an UPDATE statement to update certain columns depending on a condition
body: <p>I am wondering if this is possible at all. I want to update column x if a condition is true, otherwise column y would be updated</p>
  <pre><code>UPDATE table SET
       (CASE (CONDITION) WHEN TRUE THEN columnx
                         ELSE columny
        END)
  = 25
  </code></pre>
  <p>I have searched all over, tried out some things and am unable to find a solution. I think it's not possible, but I thought I would ask here and see if anyone has done it before.</p>