Keon Verbeeck writes a regular expression:
I have blocks of text stored inside a SQL Server table. From this text, I need to extract strings that match a specific pattern. I tried using CHARINDEX and PATINDEX, but the pattern is too complicated. Learn how this can be done with the REGEXP_INSTR function.
Read on to see how.