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

Mark Groen evolt at markgroen.com
Tue Aug 15 09:25:44 CDT 2006

On Tue, 2006-08-15 at 08:57 -0500, Casey Crookston wrote:
> >>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?

Don't know much about MS SQL, but a quick scan of the specs here:


and a little read through this article:


methinks your single quotes nested inside other quotes may be a problem, also, missed the first part of this thread so although it says the syntax error is near the +, it could be related to something further up the query?
Perhaps repeating the entire query may make a light bulb go on for someone...


More information about the thelist mailing list