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

[Casey Crookston]

This does not seem to work:

CREATE Procedure getSearchResults2
(
@search nvarchar(4000)
)
as
SELECT listing_id, RANK, name, address, city, zip, heading, phone 
FROM listings a, 
FREETEXTTABLE(listings, *, 'FormsOf(INFLECTIONAL, @search') b
WHERE [KEY] = a.listing_id
ORDER BY RANK DESC, name

GO

It always treats @search as NULL. What's wrong with my syntax here?

Thanks!

Casey

 

P.S. MS SQL 2000