求SQL语句

[dzxccsu]

-- 数据表 T
COL1 COL2
1 AAA(1256)(800022521)
2 BBB(100876747)

-- 想要的结果:
COL1 COL2
1 800022521
2 100876747

[唐诗三百首]

create table T
(COL1 int,COL2 varchar(30))

insert into T
 select 1,'AAA(1256)(800022521)' union all 
 select 2,'BBB(100876747)'
 
 
select COL1,
       reverse(substring(reverse(COL2),2,charindex('(',reverse(COL2),2)-2)) 'COL2'
 from T

/*
COL1        COL2
----------- ------------------------------
1           800022521
2           100876747

(2 row(s) affected)
*/

[lzw_0736]

WITH a1 (COL1,COL2) AS
(
SELECT 1,'AAA(1256)(800022521)' UNION all
SELECT 2,'BBB(100876747)'
)
,a2 AS
(
SELECT COL1,REVERSE(COL2) COL2
FROM a1
)
SELECT COL1,REVERSE(STUFF(LEFT(COL2,CHARINDEX('(',COL2)-1),1,1,''))
FROM a2

[dzxccsu]

都是高手，结贴！