Best way to search data stored as XML in Sql Server?
Say I have data structures stored as XML (XML data type) within Sql Server.  A user wishes to pull out a record if, within the data, a certain string is found.

What are my options for implementing this, and which is the best way to do it?

Note that each record can have different XML data structures
Best way to search data stored as XML in Sql Server?
===

Say I have data structures stored as XML (XML data type) within Sql Server.  A user wishes to pull out a record if, within the data, a certain string is found.

What are my options for implementing this, and which is the best way to do it?

Note that each record can have different XML data structures