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