批量替换MSSQL某字段中内容的SQL语句

update WM_ClassSort set WM_MetaContent=Replace(cast(WM_MetaContent as varchar(8000)),’临沂’,'{$MyCity}’)

是要替换WM_ClassSort表中WM_MetaKey这个字段里的内容，把临沂替换成{$MyCity}