Does anyone lese get the same results that I do?
tblTest has an id field and a testName field....table has 2 records:
1 kevin test 1
2 kevin test 3
SELECT *
FROM tblTest t
INNER JOIN CONTAINSTABLE(tblTest,*,'"kevin test 1"') as A ON t.id = A.[KEY]
Result is both records returned, but since the search is in quotes as an exact phrase, should not just the first record be returned?
Hi,
Numbers as considered as Noise words by Full-Text engine and are removed from Search pattern. So, your 2 records match your query.
Jean-Pierre Riehl
|||Thanks....I knew about noise words, but I did not know that it was in effect even with quotes.
No comments:
Post a Comment