先試一下這個(CCC和B表自己換一下)

select left(CCC, patindex("%金%金%",CCC))+ stuff(right(CCC,len(CCC)-patindex("%金%金%",CCC)),charindex("金",right(CCC,len(CCC)-patindex("%金%金%",CCC))),1,"銅") From B表 Where patindex("%金%金%",CCC)>0

如果能正常檢索出結果，那就可以直接寫

update B表 set CCC=(

left(CCC, patindex("%金%金%",CCC))+ stuff(right(CCC,len(CCC)-patindex("%金%

金%",CCC)),charindex("金",right(CCC,len(CCC)-patindex("%金%金%",CCC))),1,"銅

")) Where patindex("%金%金%",CCC)>0