I have Full Text Search enabled on a varchar(max) column. Some but not all rows contain XML in this column. I'd like to search for text using FT but ignore any XML elements. e.g.
SELECT Title, Text_1
WHERE CONTAINS (Text_1, '"table" AND "tbody"' );
should not return any results. The ideal solution would be to not index these elements in the first place. What are my options? I'm using SQL Server 2008