title: SQL query using CONTAINS doesn't work on specify keyword
body: <p>I am writing a simple query in SQL Server:</p>
  
  <pre><code>SELECT * 
  FROM Table1 
  WHERE CONTAINS(Column1, 'MY')
  </code></pre>
  
  <p>but it doesn't return any results. While using <code>like</code> it returns results. </p>
  
  <p>Is there any specific reason why the keyword 'MY' doesn't work?</p>
  
  <p>Update:
  If I use other keywords, it works, only the specific 'MY' seems to be that I cannot used. My column is already set into fulltext index. Also for performance purposes I prefer to use CONTAINS.</p>