i am using sql 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
views:
94answers:
1
+1
A:
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).
AlexS
2009-12-21 16:23:36
no i'm not searching with quotes i m printing my variable to control in the sql and always just 'some*' is printed
fealin
2009-12-22 11:07:23
Could you please provide a code sample of how you do the search, i.e. the query with CONTAINSTABLE?
AlexS
2009-12-22 17:10:12
Sorry that project suspended for now i m developing some more important projects for now but i ll try to send you a my code as soon as possible
fealin
2009-12-24 12:17:39