Extend Regex support in SQL Server

Category: sql server transactsql

Question

B Iordanov on Sat, 02 Mar 2013 22:46:09


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

Replies

Kalman Toth on Sat, 02 Mar 2013 23:22:07


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.

Tom Cooper on Sun, 03 Mar 2013 01:45:29


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

Kalman Toth on Sun, 03 Mar 2013 07:09:02


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

Hi Tom,

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

Tom Cooper on Sun, 03 Mar 2013 07:42:23


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

Tom

wBob on Sun, 03 Mar 2013 11:19:29


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