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