Loading...

Regex support for LOB types in T-SQL—available in Azure SQL & SQL Server 2025

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 more
Need help with this product?

We 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.

Azure SQL Devs’ Corner
Azure SQL Devs’ Corner

Voices from the Azure SQL PM Team, focusing on development and developers

Share post:

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 ...

1 day ago

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 ...

1 day ago

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...

1 day ago

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...

2 days ago

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...

7 days ago

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...

7 days ago

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. ...

9 days ago

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...

15 days ago

Newsletter

Get the latest Dynamics 365 and Power Platform content in your inbox

A curated digest of community blogs, product news, videos, and podcasts — delivered without the noise.

Weekly updates Unsubscribe anytime Fresh community picks
We use your email only for the newsletter and you can unsubscribe at any time.
By subscribing, you agree to the privacy policy.