title: Ignore Dash (-) from Full Text Search (FREETEXTTABLE) search column in SQL Server
body: <p>I use <code>CONTAINSTABLE</code> for my searching algorithm. I want to search column value with ignoring dash in particular column value. for example, column contains '12345-67' then it should search with '1234567' as below query.</p>
  
  <pre><code>SELECT * 
  FROM table1 AS FT_Table
  INNER JOIN CONTAINSTABLE(table2, columnname, '1234567') AS Key_Table ON FT_Table.ID = Key_Table.[Key]
  </code></pre>
  
  <p>Is there any way to ignore dash (-) while searching with string that doesn't contain a dash (-)?</p>