title: SQL: Like vs Contains - Different Results
body: <p>I'm running two queries on a table.</p>
  
  <pre><code>SELECT MSDS FROM dbo.MSDSSearch3 WHERE CONTAINS(MSDS, 'STYCAST')
  </code></pre>
  
  <p>And</p>
  
  <pre><code>SELECT MSDS FROM dbo.MSDSSearch3 WHERE MSDS like '%STYCAST%'
  </code></pre>
  
  <p>The first query will return </p>
  
  <pre><code>'STYCAST 50300 LV'
  </code></pre>
  
  <p>And the second will return</p>
  
  <pre><code>'STYCAST 50300 LV'
  'STYCAST 2851 BLACK'
  </code></pre>
  
  <p>Does anyone know why the like would return more values than the contains? Is there a problem with how I'm running contains? Thanks in advance.</p>