I have query like that

SELECT

Urun_ID

,Urun_Ad



FROM TBL_URUNLER


WHERE CONTAINS(Urun_Ad, '"*mta1000-*"' )



it returns

62 MTA1000-1



When i chance the search phrase mta1000-1

it returns nothing.



Urun_Ad is defined as NVARCHAR(50)

in my tbl_urunler table .

I rebuilded my fulltextcatalog before running my query



What can be the problem ?