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

Casey Crookston caseyc at IntelliSoftmn.com
Tue Aug 15 08:57:29 CDT 2006

>>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

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?


More information about the thelist mailing list