CODEWITHSUNDEEP
sqlsql-serverparameterizedformsof
Chocobo
Chocobo

Reputation: 3

Multiple quotation marks in a SQL Server stored procedure for use with FREETEXT/FORMSOF

I have been looking at this query snippet for awhile, thinking that I have the single quotes matched properly, but I keep getting blank result sets. Am I missing something here? I'm trying to find inflected versions of parametrized keyword phrases.

set @query = @query + 'AND (FREETEXT (ExampleTable.*, ''FORMSOF(INFLECTIONAL,"' + @keyword + '")'')'

Appreciate any insight. Hopefully it's just a dumb mistake on my part...

Upvotes: 0

Views: 252

Answers (1)

Steve Kass
Steve Kass

Reputation: 7184

According to this documentation page, the use of FORMSOF where you are using it (in the freetext_string parameter) seems not to be allowed. What makes you think this should work?

Upvotes: 0

Related Questions