title: SQL text LIKE doesn't always work
body: <p>I'm comparing text values in the same table and same column in SQL Server 2008, but the results are sometimes incorrect. Possibly relevant column info:  </p>
  
  <pre><code>Data type: text  
  Full Text: True  
  Collation: SQL_Latin1_General_CP1_CI_AS
  </code></pre>
  
  <p>Out of 100 actual matches I only get 62. I have compared field values that are not picked up by LIKE in some comparison tools and they are 100% same, no additional spaces, line breaks etc.</p>
  
  <p>Any idea why text LIKE doesn't always work?</p>
  
  <p>SQL:</p>
  
  <pre><code>SELECT a.text as one, b.text as two
    FROM [Db].[dbo].[Table] a join
    [Db].[dbo].[Table] b on
    a.text LIKE b.text
  </code></pre>