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 2008 Forums  Transact-SQL (2008)  Exclude xml tags from fulltext search?

Author  Topic  sjohns Starting Member 3 Posts Posted - 2010-10-01 : 09:52:01 We have an XML string stored in an ntext 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"?