I am building a search page to search through a database table on an ms sql 2000 server. I have Full-Text Indexing Enable, and it scheduled to populate all of which work fine. The problem I am having is that when I run the full text search, It is not returning accurate information.
Here is my sql statement, I have ran it through Query Analyzer.
Select * From dbo.PV_ITS_Global_FAQ Where Freetext(*,'Kenny');
Example of Data in Database
N Question Answer
1 Test <P>Kenny</P>
2 Test Kenny
3 Test Kenny2
It is my understanding that from my SQL Statment above, It should return All rows. However, it is only returning the Second Row. However, if I search for Test, It does return all rows. It looks like it matches exact wording. But I was under the impression that a FREETEXT search was more of a Fuzzy search.
thanks in advance for any help