> I have been searching for an escape character or a way of escaping
> double quotes that are actually in a string that I am using in the
> contains predicate.
>
> Here is an example
>
> select *
> from table
> where contains(field, '"he said "what is wrong", that is what he
> said"')
>
> I need the double quotes in the string because they are part of the
> text. Of course, Fulltext search raises the error
>
> Server: Msg 7631, Level 15, State 1, Line 1
> Syntax error occurred near 'what is wrong", that is what he said'.
> Expected ''''' in search condition '"he said "what is wrong", that is
> what he said"'.
>
> If I remove the double quotes, the search does not return the proper
> results.

"swtwllm" <swtwllm@alum.iup.edu> wrote in message
news:c38d6cfb.0402201036.6cdf8d87@posting.google.com...
> I have been searching for an escape character or a way of escaping
> double quotes that are actually in a string that I am using in the
> contains predicate.
>
> Here is an example
>
> select *
> from table
> where contains(field, '"he said "what is wrong", that is what he
> said"')
>
> I need the double quotes in the string because they are part of the
> text. Of course, Fulltext search raises the error
>
> Server: Msg 7631, Level 15, State 1, Line 1
> Syntax error occurred near 'what is wrong", that is what he said'.
> Expected ''''' in search condition '"he said "what is wrong", that is
> what he said"'.
>
> If I remove the double quotes, the search does not return the proper
> results.
>
> Thanks in advance for the help
> Bill