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 |
|
kiransuthar
Starting Member
9 Posts |
 Posted - 2008-11-18 : 12:46:25
|
| Hello, I am using SQL server 2005 and I am using one query which uses FTS.queries:select * from [Brands] where (FREETEXT([Name],'now'))select * from [Brands] where (Contains([Name],'now'))Above query is not returning any result. I know that there are some records which has "Now" word in it. but still its not coming in result.Can anybody help me why this is happening?ThanksKiran |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2008-11-18 : 14:55:55
|
| select * from [Brands] where Contains([Name],'"now"') |
 |
|
|
kiransuthar
Starting Member
9 Posts |
Posted - 2008-11-19 : 10:18:28
|
| Thanks for replying but select * from [Brands] where Contains([Name],'"now"') is not working.Kiran |
|
|
|
kiransuthar
Starting Member
9 Posts |
Posted - 2008-11-19 : 10:39:57
|
I got the solution for this problem.  Actually Now is a common word and may be in the noise word list so it is getting ignoredI had a look and 'now' is in there.Naviagate to $SQL_Server_Install_Path\Microsoft SQL Server\MSSQL.1\MSSQL\FTDATAand edit the NoiseENG.txt file. Remove now from it and below query will work.select * from [Brands] where (Contains([Name],'now'))ThanksKiran |
|
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2008-11-19 : 11:32:07
|
| Thanx for correcting me. |
|
|
|
|
|
|
FTS query is not working with "Now" word