Tomaz Kastrun continues an advent of SQL Server 2025. Day 8 looks at a pair of regular expression-related functions:
Continuing with SQL Server 2025 T-SQL functions for Regular Expressions for in string and count functionalities.
Last two functions in the family of new T-SQL functions that were shipped with RegEx, are REGEXP_MATCHES() and REGEXP_SPLIT_TO_TABLE().
Read on to see how all four of these work.