Louis Davidson wraps up a series on regular expressions:
I am only combining them into a short version because they are, in how they work, very similar to all the other functions. I certainly will demonstrate all the functionality for each function, but not to the extra level I have in previous blogs.
This time, I will cover:
REGEXP_INSTRReturns the starting or ending position of the matched substring, depending on the option supplied.REGEXP_COUNTReturns a count of the number of times that regex pattern occurs in a string.
Read on to see how these work in SQL Server 2025.