Extend Regex support in SQL Server

Question

Regular expression support is fairly limited in MSSQL compared to other providers (e.g. Oracle, MySQL). To get round this I create C# based CLRs but it would be more convenient if the full Regex functionality was directly available in SQL Server. Maybe Microsoft could add it in the next version of SQL Server 201(5)..?!

Bobby

Answer 1

Hi Bobby,

You can submit a proposal at Connect:

https://connect.microsoft.com/SQLServer

For success it is important that you start a campaign for UP votes.

Post the Connect link here for reference. Thanks.

---

Kalman Toth Database & OLAP Architect
Paperback / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012

Answer 2

There already is a connect item for that.  Go to https://connect.microsoft.com/SQLServer/feedback/details/261342/regex-functionality-in-pattern-matching.  Go there and vote for it.  Current vote (as of 8:43 EST Mar 2, 2013) is 253 Yes, 0 No.  The more Yes votes we get, the sooner we will see this in SQL Server.

Tom

Answer 3

> Current vote (as of 8:43 EST Mar 2, 2013) is 253

Hi Tom,

Nice vote count, but.... it is sitting there 6 years!

---

Kalman Toth Database & OLAP Architect
Paperback / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012

Answer 4

Yes, Microsoft is certainly taking their time with this one.  But at least they've left open (active), so there is still hope. 

Tom

Answer 5

For those of you Master Data Services then it is already there.