ContainsTable/FreeTexttable Ranking

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

ContainsTable/FreeTexttable Ranking

Author

Topic

Thunderchild75
Starting Member

3 Posts

Posted - 2011-10-18 : 06:00:23

Hi All,

I have this line of code


SELECT tbl_title.Rank * 18.0 AS rnk, vp.productWebTitle
 FROM  dbo.vw_validProducts vp 		 
  INNER JOIN CONTAINSTABLE(vw_validProducts, productWebTitle ,   '"Through Time "' ) AS tbl_title         
ON vp.ISBN = tbl_title.[KEY]

Ok this works fine but in the results a title with the word "Time" twice is ranked higher than a title with the phrase 'Through Time' in it, I would like the phrase to be ranked higher but I'm unsure as to how I can do this.
Any help would be very much appreciated.
Cheers

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources