I have a query that uses containstable for a free text search. I think I understand how it ranks in general but keep getting hung up on this one issue. If I query using the phrase "performance and management" I receive less records than if I used performance management wrapped in single quotes. I don't understand how it's treating the word AND in the case that the phrase is wrapped in double quotes.
Any one out here shed some light?
Here's my query:
SELECT DocTable.* FROM DocTable
INNER JOIN Containstable(DocTable, ColumnName, 'Performance and Management') As KEYTBL on DocTable.DocTableId = KEYTBL.[Key]
ORDER BY KEYTBL.RANK DESC
- OR Double Quotes -
SELECT DocTable.* FROM DocTable
INNER JOIN Containstable(DocTable, ColumnName, '"Performance and Management"') As KEYTBL on DocTable.DocTableId = KEYTBL.[Key]
ORDER BY KEYTBL.RANK DESC
Any one out here shed some light?
Here's my query:
SELECT DocTable.* FROM DocTable
INNER JOIN Containstable(DocTable, ColumnName, 'Performance and Management') As KEYTBL on DocTable.DocTableId = KEYTBL.[Key]
ORDER BY KEYTBL.RANK DESC
- OR Double Quotes -
SELECT DocTable.* FROM DocTable
INNER JOIN Containstable(DocTable, ColumnName, '"Performance and Management"') As KEYTBL on DocTable.DocTableId = KEYTBL.[Key]
ORDER BY KEYTBL.RANK DESC