Charindex() will return the first position. If you have a (low) upper bound of occurrences you can case-when them all out, or more simply expose your rdbms' regular expression function.
Charindex() will return the first position. If you have a (low) upper bound of occurrences you can case-when them all out, or more simply expose your rdbms' regular expression function.