[thelist] MS SQL Using 'FormsOf(INFLECTIONAL, ) in a full-text search

[Casey Crookston]

Hmm.  Thanks Chris - I will look into this.  FORMSOF does work with
CONTAINSTABLE, right?

-----Original Message-----


Casey

> Solved.
> 
> DECLARE @SearchWord nvarchar(4000)
> SET @SearchWord = 'tax'
> EXEC('SELECT listing_id, RANK, name, address, city, zip, 
> heading, phone 
> FROM listings a, 
> FREETEXTTABLE(listings, *, ''FormsOf(INFLECTIONAL, '+ 
> @SearchWord +')''
> )
> WHERE [KEY] = a.listing_id
> ORDER BY RANK DESC, name')

You've solved the issue of the error that you were experiencing, but it
may
be worth checking your results. As I pointed out, the documentation
specifies that FORMSOF cannot be used as the free_text parameter with
FREETEXTTABLE. Are you 100% sure that FORMSOF is being processed, and
not
simply being treated as a string? I would personally be wary of using
behaviour that differs to the behaviour stated in the documentation, as
apart from anything else this may be "fixed" in later versions; breaking
your application.

FWIW, HTH.