[thelist] MS SQL Using 'FormsOf(INFLECTIONAL, ) in a full-text search
Casey Crookston
caseyc at IntelliSoftmn.com
Mon Aug 14 17:15:46 CDT 2006
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
More information about the thelist
mailing list