Regex support for LOB types in T-SQL—available in Azure SQL & SQL Server 2025
At a glance — Native regular expression (regex) functions in T-SQL now accept varchar(max) and nvarchar(max) inputs of up to 2 MB across all seven regex functions, including the two table-valued functions (REGEXP_MATCHES and REGEXP_SPLIT_TO_TABLE). This capability ships in SQL Server 2025 CU5 and is already available in Azure SQL Database, SQL Database in Fabric and […]
The post Regex support for LOB types in T-SQL—available in Azure SQL & SQL Server 2025 appeared first on Azure SQL Dev Corner.
Published on:
Learn moreWe can help you with Regex support for LOB types in T-SQL—available in Azure SQL & SQL Server 2025
If you want help implementing, troubleshooting, or improving this product, contact us and we’ll point you in the right direction.
Related posts
PostgreSQL to SQL Field Notes: Operational Statistics
Welcome to SQL First, welcome to SQL! You’re going to like this. I’ve said this before, but it’s still true: upgrading from ...
The paper that split the database in four: inside Azure SQL Database Hyperscale, aka Socrates
Under the Hood: The Research Behind Microsoft SQL, part 1 The Microsoft SQL team is always innovating. They do this in day-to-day efforts, but...
Try SqlClient’s new connection pool for faster parallel connections
You told us that applications using Microsoft.Data.SqlClient can take too long to establish the database connections they need. When many requ...
Upcoming SQL and AI Events to Put on Your Calendar
Developers, database administrators, data professionals, architects and technology decision makers have several opportunities to connect, lear...
PostgreSQL to SQL Field Notes: Connections
Welcome to SQL First, welcome to SQL! You’re going to like this. Upgrading from PostgreSQL is real work, and depending on your old database, t...
DiskANN Vector Index and Vector Search Are Now Generally Available in Azure SQL
Today, we are announcing the general availability of DiskANN Vector Index & Search across Azure SQL Database, Azure SQL Managed Instance w...
What’s new across Microsoft SQL at SQLCon/FabCon Europe 2026
Live From Barcelona Woo! I’m posting this live from the first ever European SQLCon (joint conference with FabCon EU), and the second ever SQLC...
How to build an app on Azure SQL with an AI coding agent
Developers have trusted SQL for decades, since long before AI existed. Now coding agents help choose the database, and they favor the one they...