title: Microsoft Access 2010 LIKE clause character range (e.g., "[a-z]"]) not working
body: <p>I am developing a custom ODBC driver to which I link using external ODBC data source from Microsoft Access 2010.  I issue the following query:</p>
  
  <pre><code>SELECT column_name from table_name where column_name like '[S-T]%';
  </code></pre>
  
  <p>Access seems to cut off the WHERE clause before submitting it to the ODBC driver manager.  When I enable tracing through the ODBC Data Source Administrator, the log shows</p>
  
  <pre><code>SELECT column_name FROM table_name
  </code></pre>
  
  <p>When I remove the '[S-T]', the query works fine.  Also, the same query causing trouble in Access works fine when I run it under ODBC Test (MDAC 2.8 testing tool).</p>
  
  <p>Any idea why Access might be doing this?</p>