27,579
社区成员
发帖
与我相关
我的任务
分享
use Tempdb
go
--> --> 中国风(Roy)生成測試數據
declare @t table([A] nvarchar(31))
Insert @t
select N'123456(abc)' union all
select N'abc(def)'
SELECT A=LEFT(Col1,LEN(Col1)-1)+'('+Col2+')' FROM (Select RIGHT(A,CHARINDEX('(',REVERSE(A))-1) AS Col1,LEFT(A,CHARINDEX('(',A)-1) AS Col2 from @t) AS t
/*
A
abc(123456)
def(abc)
*/
create table test(A varchar(20))
go
insert into test values('123456(abc)'),('abc(def)')
go
select A,
substring(A, charindex('(',A, 0) + 1, charindex(')',A, 0) - charindex('(',A, 0) -1),
substring(A, 0, charindex('(',A, 0))
from test
go
drop table test
go
(2 行受影响)
A
-------------------- -------------------- --------------------
123456(abc) abc 123456
abc(def) def abc
(2 行受影响)