title: SQL Case statement with 'or' and 'and'
body: <p>Can I use a case statement as follows?</p>
  
  <pre><code>CASE
  WHEN (condition1 = 1 or 2) 
   AND   condition2 = 3
  THEN  result = 'Result'
  ELSE
  NULL
   END
  </code></pre>
  
  <p>Conditions 1 and 2 will be looking for different values, just fyi.</p>
  
  <p>If not, is there a better way to write this?</p>
  
  <p>Thank you!</p>