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)

Select allOpen in new window

Many thanks,

Rit