查询语句的效果
with t_tmp as ( select 'abcdefg(123456)xyz' as f1)
select f1,SUBSTRING(f1,1,CHARINDEX('(',f1)-1) +
SUBSTRING(f1,len(f1)-CHARINDEX(')',reverse(f1))+2,100) as f2 from t_tmp
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a50f4bfbfbedab649cf433d1fd36afc379311e18?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
对应的UPDATE为下,顺便加了过滤条件避免不是此类数据也被处理了
update 表名 set 字段名 =
SUBSTRING(字段名,1,CHARINDEX('(',字段名)-1) +
SUBSTRING(字段名,len(字段名)-CHARINDEX(')',reverse(字段名))+2,len(字段名))
where CHARINDEX(')',字段名)>CHARINDEX('(',字段名) and CHARINDEX('(',字段名)>0