title: SQL Server : searching duplicate record
body: <p>I'm trying to check for duplicate bame in SQL Server.</p>
  
  <p>Table <strong>Company</strong>:</p>
  
  <pre><code>   CompanyName            | Business
     -----------------------+----------
     Example Company INC    | Telecom 
     The Example Company    | Telecom
  </code></pre>
  
  <p>I want to get the both of the company name as duplicate. using the parameters "The Example Company INC".</p>
  
  <p>When I use </p>
  
  <pre><code>SELECT CompanyName 
  FROM COMPANY 
  WHERE CompanyName LIKE '%The Example Company INC%' 
  </code></pre>
  
  <p>it show no results. The query must return 2 records - is this possible?</p>