I want to reference a wildcard match and use that reference to populate a field.
CASE WHEN [Co1] LIKE 'User%' THEN [Col2] = [the respective User% matched earlier]
How can I do that?
I know how to do it in REGEX, where you use parenthesis in the wildcard to reference the match and then you use \1 to use that wildcard match.
But what is the equivalent in SQL?