title: Conditional CASE statement syntax
body: <p>I need help writing a case statement for a view.  The base table has 2 columns that I'll be referencing: 'Stage' and 'YesNo'.</p>
  
  <p>If Stage column is 1, and the YesNo column is 1, I need the CASE statement to show it in the view as 'No.'  If the Stage column is 1, and the YesNo column is 0, I need the CASE statement to show it in the view as 'Yes.'  If the Stage column is 1, and the YesNo column is NULL, I need the CASE statement to show it in the view as NULL.  If the Stage is anything other than 1, I need the YesNo column to show in the view as NULL.</p>
  
  <p>This is my logic so far which I think is correct, but when I try to run it, I get a syntax error about the word 'AS'. Any suggestions?</p>
  
  <pre><code>CASE 
      WHEN a.Stage = 1 and a.YesorNo = 1 THEN 'No' 
      ELSE WHEN a.Stage = 1 and a.YesorNo = 0 THEN 'Yes' 
  END AS NewViewColumn
  </code></pre>