title: Case expression syntax error near "as"
body: <p>I'm getting an error on my case expression. I just want to evaluate one condition, and return the proper statement. But I keep getting a syntax error near "as".</p>
  
  <p>Here's what I have:</p>
  
  <pre><code>left outer join (            
          SELECT wbs1, wbs2, wbs3  
      , case 
              when (ProgramAffiliation = magrann.[programAffiliation_AEP/COHesh2010]()) 
              then '[AEP] as ''AEP1'''
              else [AEP Base] as 'AEP1'
          end
      , [AEP:Non-Compliant Mechanical Ventilation] as 'AEP2'  
      , [AEP - Non Energy Star AC ($90 deduction)] as 'AEP3'  
      , [AEP: Bonus] as 'AEP4'
  </code></pre>