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

[Casey Crookston]

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')