How to search double quotes in fulltext search in sql?

Can an Sql 2008 full text predicate combine "phrase" with FORMSOF()?

• I am trying to get SQL 2008 full text index to search for a phrase (multiple words in double quotes that should appear in sequence) while allowing thesaurus equivalents of the words to be matched. (Example, a search for "silver bullet" with a thesaurus entry saying bullet==slug should match "silver bullet" or "silver slug" but should not match "silver and gold slug") The closest I got was using: where CONTAINS([FreeTextColumn], 'FORMSOF(THESAURUS,"silver bullet")') But the results I get seem to be equivalent to: where CONTAINS([FreeTextColumn],' "silver bullet" OR slug ') rather than: where CONTAINS([FreeTextColumn],' "silver bullet" OR "silver slug" ')

• Answer:

  Thanks for the links Macklin. Unfortunately, from what I have read there, the details of combining FORMSOF with a quoted phrase are not discussed. After many experiments, I was so far unable to find a full text predicate that works well with this combination. I'd love to find out that I am simply missing something but at this point I be lieve this is a shortcoming of Microsoft's implementation of free text search in SQL 2008.