请大家改一个正则
where a.OwrDate>= cast(( '2019-03' +'-01') as datetime)
and a.OwrDate<DATEADD(mm,1,cast(( '2019-03' +'-01') as datetime))
and c.SID='[&SID]' ) a group by SID,Name
比如上面这段字符,我要匹配出来关键字 c.SID='[&SID]' ,原来有朋友帮写过一个正则 (?=\s*)(\w+\.)?\w*[\W|like]*&{0}\W*,但匹配出来的结果是 c.SID='[&SID]' ) ,即把后面的)也匹配出来了,请大家帮忙改一下。