title: SQL: transform full-text search into like construction
body: <p>I've got stored procedure that performs search using full-text indexes in general case. But I can't build full-text index for one field, and I need to use LIKE construction.</p>
  
  <p>So, the problem is: parameter could be</p>
  
  <blockquote>
    <p>"a*" or "b*"</p>
  </blockquote>
  
  <p>like parameter for <code>CONTAINS</code> command.</p>
  
  <p>Сan anyone give a good solution, how to transform this parameter for <code>LIKE</code> construction.</p>
  
  <p>Thank you.</p>
  
  <p>P.S: I use <code>MSSQL Server</code></p>