Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do queries with containstable handle AND?

Status
Not open for further replies.

zerkat

Programmer
Jul 12, 2007
103
US
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


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top