Re: search error

Tom,
You have multiple word or phrase search condition and you need to wrap both
words within double quotes, for example:

.... contains(jobdescription,'"Benefits clear"')

This will return the phrase "Benefits clear" in the FT-enable column
jobdescription, if this phrase exists in this column. You might find the
following KB article helpful too: 246800 (Q246800) "INF: Correctly Parsing
Quotation Marks in FTS Queries" at
http://support.microsoft.com//default.aspx?scid=kb;EN-US;246800

Regards,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/



"tshad" <tfs@xxxxxxxxxxxxxx> wrote in message
news:#R9kgF8QFHA.2132@xxxxxxxxxxxxxxxxxxxxxxx
> Why do I get the error:
>
> System.Data.SqlClient.SqlException: Syntax error occurred near 'clerk'.
> Expected ''''' in search condition 'Benefits clerk'.
>
> I get this from:
>
> ... contains(jobdescription,'Benefits clear')
>
> Thanks,
>
> Tom
>
>


.

Relevant Pages

  • Re: search error
    ... >> Tom, ... >> You have multiple word or phrase search condition and you need to wrap ... if this phrase exists in this column. ... Is there a way of telling the regex to ignore changes inside quotes? ...
    (microsoft.public.sqlserver.fulltext)
  • Re: David Bakers "How To Play Bebop"
    ... Tom R wrote: ... upbeats is necessarily confined to the end of a phrase. ... I love Bird's use of the 9th on downbeats and upbeats ... you learning heads, and learning the etudes out of his books. ...
    (rec.music.makers.guitar.jazz)
  • Re: search error
    ... > You have multiple word or phrase search condition and you need to wrap ... not" with double quotes as well as "or not". ... Tom ...
    (microsoft.public.sqlserver.fulltext)
  • Re: OT- Your Taxes at Work
    ... "I wonder why Tom wasn't offended? ... "intent" of the phrase is more important than the phrase itself and that ... Kevin W. Miller ...
    (rec.outdoors.rv-travel)
  • Re: A no more deserving candidate!
    ... Now, Tom, you know you're not supposed to talk about Miguel using the ... phrase "bad break", particularly when it refers to a leg... ...
    (rec.motorcycles.racing)
Loading