How do you escape a double quote character inside a MS SQL 'contains' function?
WHERE CONTAINS(decision, '34" AND wide')
Punctuation is ignored. Therefore,
CONTAINS(testing, "computer failure")matches a row with the value, "Where is my computer? Failure to find it would be expensive."
FULLTEXT does not even index the punctuation, you'll need to fine-filter your results using
SELECT decision FROM table WHERE CONTAINS(decision, '34 AND wide') AND decision LIKE '%34"%'
This will preserve the benefits of fulltext.