--写个函数完成替换处理
create function f_replace(@zdbh varchar(1000))
returns varchar(8000)
as
begin
declare @ varchar(8000)
set @=','+@zdbh+','
select @=replace(@,','+rtrim(zdbh)+',',','+rtrim(zdbhname)+',')
from b
where charindex(','+rtrim(zdbh)+',',@)>0
return(substring(@,2,len(@)-2))
end
go