delete characters between parentheses?# Database - 数据库
a*t
1 楼
Hi,
I can do this in sql server -
select * where cln1 like '%(%)%'
however, if I want to delete the characters between parentheses, I can't use
replace( cln1, '(%)','').
Anyone knows how to do it?
Thanks a lot!
I can do this in sql server -
select * where cln1 like '%(%)%'
however, if I want to delete the characters between parentheses, I can't use
replace( cln1, '(%)','').
Anyone knows how to do it?
Thanks a lot!