Using FormsOf(INFLECTIONAL, )

[Casey]

This does not seem to work:

CREATE Procedure getSearchResult s2
(
@search nvarchar(4000)
)
as
SELECT listing_id, RANK, name, address, city, zip, heading, phone
FROM listings a,
FREETEXTTABLE(l istings, *, 'FormsOf(INFLEC TIONAL, @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

[Casey]

I should be more clear:

DECLARE @SearchWord nvarchar(4000)
SET @SearchWord = 'tax'
SELECT listing_id, RANK, name, address, city, zip, heading, phone
FROM listings a,
FREETEXTTABLE(l istings, *, 'FormsOf(INFLEC TIONAL, @SearchWord')
WHERE [KEY] = a.listing_id
ORDER BY RANK DESC, name

This returns no results. But this...


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

returns over 500 results

????????

[Casey]

Please! Can nobody help? I am really stuck here!

Casey

[iam_clint]

you have two opening ( but one closing, not sure if that makes a difference in my scripting languages it would

FREETEXTTABLE(l istings, *, 'FormsOf(INFLEC TIONAL, tax'))

also your variable up there has quotation around it you might try removing the quotation