The following Query is not returning any results...
SELECT Data.RSSFeedsData_Data, WEIGHT.RANK AS RSSFeedRanking
FROM RSS_Feeds_Data Data INNER JOIN
CONTAINSTABLE(RSS_Feeds_Data, RSSFeedsData_Data, 'ISABOUT ("height")') WEIGHT ON Data.RSSFeedsData_ID = WEIGHT.[KEY]
ORDER BY WEIGHT.RANK DESC
But if I use this query it does return the results..
SELECT RSSFeedsData_Data
FROM RSS_Feeds_Data Data
WHERE (RSSFeedsData_Data LIKE '%height%')
Anyone have a idea why it is not returning any results? Below is my table structure..
RSSFeedsData_ID int
RSSFeedsData_FeedID int
RSSFeedsData_Data text
RSSFeeds_Error nvarchar(500)
RSSFeedsData_DateArchived nvarchar(20)