Full Text Query - ISABOUT - SQL Server Forums

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 2000 Forums

SQL Server Development (2000)

Full Text Query - ISABOUT

Author

Topic

redbrad0
Posting Yak Master

176 Posts

Posted - 2005-04-20 : 13:13:38

Hopefully someone can help me return better results with my query. Below is the Query I am using and the example I will be searching thru the database for Universal Term Life Insurance and Premium Term Life Insurance. It appears that the query is trying to find the exact two phrases. If you do a search on google Search Link the first result has life insurance premiums being found. How is this done in the Query? Anyone have any ideas how I could open up the Query so it might find some results instead of looking for that exact phrase?


SELECT     TOP 5 Data.Data_Title, Data.Data_Link, Data.Data_Desc, Data.Data_Desc_Checksum, 
                      WEIGHT.RANK AS RSSFeedRanking
FROM         RSS_Feeds_Data Data INNER JOIN
                      CONTAINSTABLE(RSS_Feeds_Data, Data_Desc, 'ISABOUT ("Universal Term
                      Life Insurance" weight (.9), "Premium Term Life Insurance" weight (.8), )') WEIGHT ON 
                      Data.Data_ID = WEIGHT.[KEY]
ORDER BY WEIGHT.RANK DESC

Quality NT Web Hosting & Design

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources