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)
 How to exclude <Fields> from fulltext search

Author  Topic 

sjohns
Starting Member

3 Posts

Posted - 2010-10-01 : 09:03:15
We have an XML string stored in a column (one tag being named "<Fields>", along with some string values. In doing a CONTAINS query, I found that searching on "Fields" returns every record in the table. So I added the string <Fields> to a custom stoplist and attached it to the fulltext index, but now the index doesn't contain any values for "Fields", either. (must be ignoring the brackets) Is there a way to exclude "<Fields>" without excluding "Fields"?

sjohns
Starting Member

3 Posts

Posted - 2010-10-01 : 09:51:01
sorry, wrong forum (using 2008) Will move.
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-10-01 : 09:53:27
Redirect here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=150958
Go to Top of Page
   

- Advertisement -