title: Does MS Access support "CASE WHEN" clause if connect with ODBC?
body: <p>Does ODBC support <code>CASE WHEN</code> clause for MS Access? Is there any other database which does not support the <code>CASE WHEN</code> clause? I tried the following query while connecting to MS Access with ODBC but get an exception.</p>
  
  <p><code>SELECT (CASE WHEN (AGE &gt; 10) THEN 1 ELSE 0 END) FROM demo</code></p>
  
  <p><code>[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(CASE WHEN (AGE &gt; 10) THEN 1 ELSE 0 END)'</code></p>
  
  <p>I'm try to find a common way which works for most of the database to generate (compute) the new 'boolean columns' with an comparison expression while connect with ODBC. Actually, MS Access support the comparison in SELECT clause, but for some other databases CASE clause are needed. For MS Access, the SQL can be </p>
  
  <p><code>SELECT AGE &gt; 10 FROM demo</code></p>
  
  <p>but in others it have to be </p>
  
  <p><code>SELECT (CASE WHEN (AGE &gt; 10) THEN 1 ELSE 0 END) FROM demo</code></p>