[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