[thelist] Relevancy Algorithm for ASP
Wade Armstrong
wade_lists at runstrong.com
Wed Mar 5 15:41:02 CST 2003
on 3/5/03 1:25 PM, Rob Smith at rob.smith at THERMON.com wrote:
>> From the Northwinds examples:
>
> SELECT FT_TBL.Description,
> FT_TBL.CategoryName,
> KEY_TBL.RANK
> FROM Categories AS FT_TBL INNER JOIN
> CONTAINSTABLE (Categories, Description,
> '("sweet and savory" NEAR sauces) OR
> ("sweet and savory" NEAR candies)'
> , 10
> ) AS KEY_TBL
> ON FT_TBL.CategoryID = KEY_TBL.[KEY]
>
> My attempts at adding % before "%weet and..." results in failed searches.
I don't think that you can use traditional SQL Server wildcards with
full-text catalogs. I think here's where you need to use INFLECTIONAL
as in
CONTAINS([column], 'FORMSOF (INFLECTIONAL, [input]) ')
OTOH, somebody smarter might tell you otherwise!
Wade
More information about the thelist
mailing list