title: get the result from column2 when column1 is selected
body: <p>I want to get the result from column2 when column1 is the case. I get the error '"%s: invalid identifier"' when I try the code below. This is a very simple example that I stripped from my code, but need it achieved this way.</p>
  
  <pre><code>CASE columnname
  
  WHEN 'Column1' THEN 
   Column2
  
   END AS
   "MY RESULT"
  </code></pre>