Problem in Full Text Index Search

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Problem in Full Text Index Search

Author

Topic

Rameshwar
Starting Member

4 Posts

Posted - 2011-09-16 : 09:32:49

select * from Empolyees
where contains(City,'__City_Name:London')

The above query returns expected result but below query returns all the result.

select * from Empolyees
where contains(City,'__City_Name:the')

I have stored this data in below format
Table Data :
ID Text
1 __City_Name:New __City_Name:York __Description:The new york city
2 __City_Name:Las __City_Name:Vegas
3 __City_Name:London __Description:The london city

Please provide me solution for this problem

Thanks in advance...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources