尝试这样:-
select
columnname
from
MyTable
where
columnname.value('(/Weather/Forecast)[1]', 'varchar(max)') like 'StringToSearchFor'
或如此链接中所建议的那样:-
SELECT
[xmlField].value('(/Weather//Forecast/Description/node())[1]', 'nvarchar(max)') as columname
FROM [myTable]