那不是"在xml中吗?即
"
"hi "mom" lol"
**编辑:**测试; 工作良好:
declare @xml xml set @xml = '' select @xml.value('(//item/@value)[1]','varchar(50)')