Where doing a search on an SQL Server 2005 fulltext catalog for part numbers, I don't get correct answers. In fact, the results are accurate for all the characters in the search up to the first hyphen.
Say I search for "326 IAC 2-6.1-7" (including the quotes) I get results for "326 IAC 2". This a problem as searching for reference numbers formatted like this is a viatl part o the search functionality of our db.
How can I make sure the above search only returns rows that match the input text exactly?