are there any special conditions with '*' character in full text search

i am using 开发者_如何学Pythonsql server 2005 i have a stored procedure which searches database with containstable method the problem is when i search some prefix with '*' character i can't see the records which have full word just records with only prefixes. for example i search 'some' then set my variable to 'some*' and i have 'some' and 'something' records in my database but result is only the record with 'some' is there a special condition with '*' character

I guess you've just forgot to quote your search text: you should be searching for CONTAINSTABLE(...,'"some*"') and you might be using CONTAINSTABLE(...,'some*') instead. In a latter case full text search does not treat '*' as a wild card symbol (according to MSDN).