Why is fulltextsearch for phrase ignored in SQL Server?
- by cpt.oneeye
I am executing the following SQL statement on an indexed SQL Server 2008 R2 database.
SELECT * FROM mydatabase WHERE (CONTAINS(ColumnA,'"The Apple is red"'))
The problem is that it returns too many entries. It also returns entries where 'ColumnA' contains only one of the words ('Apple' or 'is' or 'red'...) and not only the entries which contains the exact phrase.
According to MSDN this should be the way to search for a phrase.
Thanks
cpt.oneeye