title: Invalid column name in case statements in SQL
body: <p>I have a SQL query which includes the following SELECT terms:</p>
  
  <pre><code>SUM(CASE WHEN JobResponses.result = "true" THEN 1 ELSE 0 END) AS [True],
  SUM(CASE WHEN JobResponses.result = "false" THEN 1 ELSE 0 END) AS [False],
  </code></pre>
  
  <p>However, when I use this is a SQL Server query, I got the syntax error:</p>
  
  <blockquote>
    <p>Invalid column name 'true'.</p>
  </blockquote>
  
  <p>obviously <code>result</code> is the reference to the column name, so why am I getting this error? It seemed to work fine on SQLite??</p>