select
<column_name>
from
MyTable
where
<column_name>
.value('(/root/sub-tag)[1]', 'varchar(max)') like 'StringToSearchFor'
or
![](https://images2017.cnblogs.com/blog/106015/201710/106015-20171027142528851-972319660.png)
These pages will show you more about how to query XML in T-SQL:
Querying XML fields using t-sql
Flattening XML Data in SQL Server
找了半天才找到!!不容易!