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

[Casey Crookston]

>>I think you need to adjust your quotes. Something like this:
FREETEXTTABLE(listings, *, 'FormsOf(INFLECTIONAL, ' + @search + ')' ) 
In other words you need to splice @search into the string using + I
think.<<

Yup tried that: Line 5: Incorrect syntax near '+'.

I am 100% astounded that I can't find the solution on Google.  Has
NOBODY ever had this problem before?

Casey