Microsoft is introducing Regular Expression(regex) functions in its upcoming SQL Server 2025 to enable pattern-based searching and manipulation. This allows searching and manipulating data directly using T-SQL language and eliminates the need of programming languages such as Python.
In this article, we will learn about these new Regex T-SQL functions. We will see their usage for searching and manipulating data.
Note: SQL Server 2025 is currently in preview mode and some features may not give satisfactory results. The RTM (Release to Manufacturing) version is expected around October 2025, which will bring more stability and refinements.
Regex Functions
Let’s understand the