SQL Server full text search and spaces
<p>I have a column with a product names. Some names look like ‘ab-cd’ ‘ab cd’
Is it possible to use full text search to get these names when user types ‘abc’ (without spaces) ? The <code>like</code> operator is working for me, but I’d like to know if it’s possible to use full text search.</p>