title: Firebird - update row's value in table basing on some condition
body: <p>As far as I remember I could do such update in MS SQL Server:</p>
  
  <pre><code>UPDATE MyTable SET MyValue = (IF SomeCondition THEN 1 ELSE 0 END)
  </code></pre>
  
  <p>or different way for update by using CASE:</p>
  
  <pre><code>UPDATE MyTable  SET MyValue  = (CASE WHEN SomeCondition1 THEN 1 ELSE 0 END)
  </code></pre>
  
  <p>Is any of this methods possible in Firebird? I've tried both ways but with no luck.</p>
  
  <p>Thanks for answers.</p>