Posted on 2014-11-23
I am trying to work out a SQL regex match for a field.
So lets say I have a field called data1 that contains:
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.SystemGroupName = "AAA\\AdGroup1"
I want to be able to do a T-SQL select statement that will just extract the string AdGroup1
from the above expression.
So how can I get a capture group. So to use a regex like below and just get the capture group: