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
New Create and Apply wizards in SSMS (Preview)
Need to save a database schema, move schema and data to another environment, or deploy a DACPAC to an existing database but find the existing ...
Build locally with Azure SQL Database container, now in public preview
Azure SQL Database container: build locally, test continuously, ship to Azure. Today at Microsoft Ignite, we’re announcing the public preview ...
MSSQL Extension for VS Code: Local Azure SQL Database Provisioning, Query Performance Dashboard, and more
A local database is a useful starting point, but deploying it and understanding how queries behave should fit into the same development workfl...
What’s new across Microsoft SQL at Microsoft Ignite 2026
From Microsoft Ignite I’m here in San Francisco enjoying specialty lattes, fall-ish weather (I guess?), and all the excitement around Microsof...
Resources for the SQL AI Developer
I see three agentic stories shaping SQL’s future. Here’s how DP-800 connects the pieces and helps you build the skills to put SQL’s AI capabil...
What’s new across Microsoft SQL in 2026 so far: the PASS Summit West roundup
[almost] A year of building on Microsoft SQL – 2026 I’m back with a really long and exhaustive list of updates across Microsoft SQ...
How do you run a query against data the database can’t read?
Under the Hood: The Research Behind Microsoft SQL, part 3 Encryption at rest solves one threat. It stops someone who walks off with the disk. ...
My Favorite Undocumented Feature in SQL MCP Server
Deploy Microsoft's SQL MCP Server in minutes without a configuration file. Learn how DAB_CONNSTRING enables fast deployment using Docker, Azur...