title: CONTAINSTABLE wildcard fails on phrase match?
body: <p>I have a search query that takes a phrase typed in by the user and should return a result, here is an example:</p>
  
  <pre><code>SELECT rank,[KEY] FROM CONTAINSTABLE(tblproduct, (title,subtitle,publisher_name),  @search_text,15)
  </code></pre>
  
  <p>Where @search_text is</p>
  
  <pre><code>Set @search_text = '"my favourite word*"'
  </code></pre>
  
  <p>The phrase, as it stands, is an exact title match to a book in the database. However, the wildcard (*), makes it so that it doesn't return ANY results.</p>
  
  <p>When I omit the wildcard, I get an exact phrase match, however, some other phrases, like "The Imperfectionists" returns no results with or without the wildcard in place.</p>
  
  <p>Why is this? What can I check?</p>
  
  <p>Currently, if no result-set is generated for the wildcard, I run the query without the wildcard to see if it returns anything. If that fails too, I run a normal "like" statement.</p>
  
  <p>Obviously the like statement will take forever... and I don't want to use it on a 7.6 million-strong database for a search that's supposed to be done with fulltext...</p>
  
  <p>Any help appreciated!</p>