declare @s varchar(4000)
set @s=divisions_name
set @s=replace (@s,'市','')
set @s=replace (@s,'盟','')
.
.
.
.
这样好像比较容易阅读
set @s=divisions_name
set @s=replace (@s,'市','')
set @s=replace (@s,'盟','')
.
.
.
.
这样好像比较容易阅读
from
(select val='市' union all
select '盟' union all
...) A