'Contains' problem

Hello,
I have a problem with a contains clause. I believe I have the full-text
index set correctly. Whenever I put a '-' (dash) character in the query, it
seems to return incorrect results.
Here is a query that works.
SELECT DISTINCT Store_Products.Family As [key] FROM Store_Products WHERE
CONTAINS(Store_Products.*, ' "suit*" ')
Here is one that does not.
SELECT DISTINCT Store_Products.Family As [key] FROM Store_Products WHERE
CONTAINS(Store_Products.*, ' "9-076*" ')
Now, if I change the query to the following, taking out the 'dash'
character, it returns what it should.
SELECT DISTINCT Store_Products.Family As [key] FROM Store_ProductsWHERE
CONTAINS(Store_Products.*, ' "076*" ')
I am not sure where to look to fix this. Thank you for your time.this may be helpful for you:
PRB: Dashes '-' Ignored in Search with SQL Full-Text and MSIDXS
Queries
http://support.microsoft.com/kb/200043/EN-US/|||very helpful. thank you.
"szeying.tan" <szeying.tan@.gmail.com> wrote in message
news:1110237167.585809.173180@.f14g2000cwb.googlegroups.com...
> this may be helpful for you:
> PRB: Dashes '-' Ignored in Search with SQL Full-Text and MSIDXS
> Queries
> http://support.microsoft.com/kb/200043/EN-US/
>