Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
don.lavelle
Starting Member
1 Post |
 Posted - 2010-01-28 : 09:19:46
|
Hi all,I'm trying to use FREETEXT to search through some data. From what I understood, FREETEXT is supposed to find inflections. However, I'm not finding that. As in,DECLARE @VALUE NVARCHAR(100)-- SET @VALUE = 'deployable' -- matches deployable-- SET @VALUE = 'deployables' -- nothing-- SET @VALUE = 'deploy' -- matches deploy-- SET @VALUE = 'deploying' -- matches deploySELECT * FROM FREETEXTTABLE([MY_TABLE], [MY_COLUMN], @VALUE) I would expect all of these search terms to get all of the results, at least with a low rank. Instead, I get only the result indicated in the comments. Am I not understanding how this feature works, or is there some setup item I missed? I followed the setup instructions at http://www.codeproject.com/KB/database/SQLServer2K8FullTextSearh.aspx.Thanks, Don |
|
|
|
|
|
FREETEXT and inflections not working as expected