Hi,
We are using freetexttable as our search function in our application and it seems to be partially working. I search for a word from a column of a table I included in the search catalog and it sometimes pickup the record and sometimes it doesn't. I got 2 records having 'business' as the keyword. And when I search that keyword, it only returned 1 record.
here is the codesnippet:
select * from freetexttable(<tablename>, *, 'business')
Any help is greatly appreciated.
Baldwin
bbudiongan@.misicompany.com
Are the two keyword int he same column ? if no, are there different word breakers defined on the column ? Are the two columns freetextindexed ?Jens Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment