先试一下这个(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('%金%... |