SQL Full Text search containg hyphen "-"
Posted on 2004-08-28
I am searching a database that contains descriptions of various millitary and commercial models. I use full text indexing with the contains statement for almost all of these searches. I need to be able to seach for planes like a B-17, F105, C-5, etc. What I have learned is the FT search ignores the "-" hyphen. It also then ignores the letter preceding the hyphen. Which then leaves me searching for 17, 105, 5. The first two return more results than I want, since lots of other items contain 17 or 105. But the last is a problem since 5 by itself will also be ignored. Is there a way to work around this? Can I somehow force or trick the FT index into searching for the the full word including the hyphen?