27,580
社区成员
发帖
与我相关
我的任务
分享
update 老邓 set ciname= CASE WHEN PATINDEX('%(%', ciname) > 0
THEN replace(replace(SUBSTRING(ciname, 0, PATINDEX('%(%', ciname)),'-N-G-1',''),'DCS','')
ELSE replace(replace(ciname,'-N-G-1',''),'DCS','')
END;