declare @s varchar(20) set @s='123(333)' select stuff(@s,charindex('(',@s), charindex(')',@s)-charindex('(',@s)+1,'') ------------------------------------------------------- --下面实现表的更改 update a set B=stuff(B,charindex('(',B), charindex(')',B)-charindex('(',B)+1,'') where charindex('(',B)>0
create table a( cc varchar(20)) insert a select '123(333)' union all select '123(333)12' union all select '(333)123'update a set cc=left(cc,charindex('(',cc)-1) + right(cc,len(cc)-charindex(')',cc)) select * from acc -------------------- 123 12312 123(所影响的行数为 3 行)
create table AAAA(B列 varchar(20)) go insert AAAA values('123(333)') insert AAAA values('123ttt(ttttt)') insert AAAA values('123(333') insert AAAA values('123333)') insert AAAA values('123333') go select * from AAAA where (charindex('(',B列)>0 and charindex(')',B列)>0)update AAAA set B列=stuff(B列,charindex('(',B列),charindex(')',B列)-charindex('(',B列)+1,'') where charindex('(',B列)>0 and charindex(')',B列)>0select * from AAAAdrop table AAAA
set @s='123(333)'
select stuff(@s,charindex('(',@s),
charindex(')',@s)-charindex('(',@s)+1,'')
-------------------------------------------------------
--下面实现表的更改
update a set B=stuff(B,charindex('(',B),
charindex(')',B)-charindex('(',B)+1,'')
where charindex('(',B)>0
create table a( cc varchar(20))
insert a
select '123(333)'
union all
select '123(333)12'
union all
select '(333)123'update a
set cc=left(cc,charindex('(',cc)-1) + right(cc,len(cc)-charindex(')',cc)) select * from acc
--------------------
123
12312
123(所影响的行数为 3 行)
create table AAAA(B列 varchar(20))
go
insert AAAA values('123(333)')
insert AAAA values('123ttt(ttttt)')
insert AAAA values('123(333')
insert AAAA values('123333)')
insert AAAA values('123333')
go
select * from AAAA where (charindex('(',B列)>0 and charindex(')',B列)>0)update AAAA set B列=stuff(B列,charindex('(',B列),charindex(')',B列)-charindex('(',B列)+1,'')
where charindex('(',B列)>0 and charindex(')',B列)>0select * from AAAAdrop table AAAA