title: Case insensitive schema object names with case sensitive comparisons
body: <p>Is there any way to mix case <strong>insensitive</strong> schema object names with case <strong>sensitive</strong> comparisons in SQL Server?</p>
  
  <p>All string columns in my database use a CS (case sensitive) collation however I can't switch to a CS collation at the database level because it's managed by a legacy application that uses inconsistent schema object name casing in the queries it makes.</p>
  
  <p>For example, I need the following query to successfully execute and return 0:</p>
  
  <pre><code>select count(*) from PeRsOn where 'A' = 'a'
  </code></pre>