1 800022521 AAA(1256)(800022521) 2 100876747 BBB(100876747)
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
原文：http://www.cnblogs.com/emmy/p/4305368.html