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

[Casey Crookston]

>>Perhaps repeating the entire query may make a light bulb go on for
someone...<<

Thanks Mark,

DECLARE @SearchWord nvarchar(4000)
SET @SearchWord = 'tax'
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

This returns no results. It treats the paramater as a NULL value.  But
this...


SELECT listing_id, RANK, name, address, city, zip, heading, phone
FROM listings a,
FREETEXTTABLE(listings, *, 'FormsOf(INFLECTIONAL, tax')
WHERE [KEY] = a.listing_id
ORDER BY RANK DESC, name

returns over 500 results.