一个小有难度的SQL

Question

declare @s varchar(100)
set @s='(aabbbcccddd)'
select col=substring(@s,charindex('(',@s)+1,charindex(')',@s)-charindex('(',@s)-1)結果：aabbbcccddd
declare @s varchar(100)
set @s='sdrfwe(aabb12547cddd)hehrer'
select col=substring(@s,charindex('(',@s)+1,charindex(')',@s)-charindex('(',@s)-1)結果：aabb12547cddd

Answer 1

select replace(replace(字段,'(',''),')','')

Answer 2

select replace(replace(列名,'(',')'),')','') from 表名 where ...