Have you seen REGEX_SPLIT_TO_TABLE() yet? It's new in SQL Server 2025 and is a complete upgrade from STRING_SPLIT(). STRING_SPLIT() only lets you split on a single character - but the new function can ...
Regex String Split using SQL Server 2025 REGEXP_SPLIT_TO_TABLE by Koen Verbeeck >>> https://lnkd.in/eW9kH2Zh In the new SQL Server 2025 release, support for regular expressions (regex) has been added ...