CODEWITHSUNDEEP
sql-serversql-server-2012freetexttable
HaBo
HaBo

Reputation: 14317

SQL Server freetexttable special characters

When I use FreeTextTable in SQL Server and pass search key with a special character like hyphen, it looks for all results matching for keyword partone or keyword parttwo.

How can I restrict it doing that and search for partone=parttwo as one word? if that is not possible what are my alternates, I am dealing with large number of rows.

select * 
from freetexttable(dbo.TableName, (FieldOne, FieldTwo), 'partone-parttwo')

Upvotes: 1

Views: 110

Answers (0)

Related Questions