title: How do I perform an exact string match on a non-case sensitive field?
body: <p>I would like to find all the rows in a table and match on an exact case sensitive string. Unfortunately, my table has the case insensitive collation. </p>
  
  <p>What is the most efficient way to perform this.</p>
  
  <p>Eg.</p>
  
  <p>I would like the following to return no rows:</p>
  
  <pre><code>select * from sysobject where name = 'Sysbinobjs' 
  </code></pre>
  
  <p>For the answer assume @match is in a variable: </p>
  
  <pre><code>declare @match varchar(4000) 
  set @match = 'sysbinobjs'
  </code></pre>
  
  <p><strong>EDIT</strong> </p>
  
  <p>Clarification, make sure trailing spaces are treated properly, I want an exact match that takes account of trailing spaces so 'Hello' will only be matched with 'Hello' and not with 'Hello     ' </p>