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:
Microsoft SQL ServerMicrosoft SQL Server 2008SQL
8/22/2022 - Mon
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst