title: SQL FREETEXT Search Escaping Space
body: <p>I have a Thesaurus table in my database, I want to collect data using FREETEXT. However the string I'm searching for contains spaces.</p>
  
  <p>For example, I want to search for the code "AB 001"</p>
  
  <pre><code>select * 
  from TheThesaurus
  where freetext(TheDefinition, 'AB 001')
  </code></pre>
  
  <p>This code will search for both "AB" and "001", which will give me a lot more junk results. I tried putting the string in double quotes, but it's not working either.</p>
  
  <pre><code>select * 
  from TheThesaurus
  where freetext(TheDefinition, '"AB 001"')
  </code></pre>
  
  <p>How can I do so I can search for the full "AB 001" string??</p>
  
  <p>I used LIKE and it's giving me the desired result, but I want to try full-text search since it is much faster and will give more accurate result in my case.</p>
  
  <pre><code>select * 
  from TheThesaurus
  where TheDefinition LIKE '%AB 001%'
  </code></pre>
  
  <p>Thanks!</p>
  
  <h2>EDIT</h2>
  
  <p>I tried using <code>CONTAINS</code>, but it was giving me extra results that I could not understand why they are being returned. The <code>CONTAINS</code> function doesn't work for me either :/</p>
  
  <pre><code>select * 
  from TheThesaurus
  where Contains(TheDefinition, 'AB%001')
  </code></pre>