SQL Server CONTAIN() Ranking

Hi All,

I am using the following SQL which queries a View that has full text indexing enabled on a column call SearchContent.

I was under the impression that the records would be returned in rank order with the record with the most instances of the search term appearing at the top. But this doesn't seem to be the case.

Can anyone suggest what I could be doing wrong or provide alternative code to achieve this?

SELECT ProductName, ProductID
FROM ProductViewSearch
WHERE CONTAINS(SearchContent, 'tomy') AND 
ProductCatgeory IN(1,3,5)

Open in new window


Many thanks,

Rit
LVL 1
rito1Asked:
Who is Participating?
 
jogosCommented:
0
 
rito1Author Commented:
Brilliant thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.