替换文中指定字段实例

select * from dbo.QD_News where Contents like '%FONT-FAMILY: 仿宋_GB2312;%'
update dbo.QD_News set Contents=replace(covert(ntext,Contents),'FONT-FAMILY: 仿宋_GB2312;'，'FONT-FAMILY: 宋体;')
update dbo.QD_News set Contents=replace(convert(varchar(8000),Contents),'FONT-FAMILY: 仿宋_GB2312;','FONT-FAMILY: 宋体;')