[thelist] Relevancy Algorithm for ASP

[Rob Smith]

>EXEC sp_fulltext_catalog '[catalogname]', 'start_full'

I'd say that was an important feature to have. I had to start the Catalog
before it gave any results. Now that I've got results, how do I add wild
card characters (%)?

>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.

Thanks for your help Wade (and others who want to chime in)

Rob