Support for regular expressions
Good evening, I recently started a new position at a company running on MS SQL Server. I work in the business of data transformation and constantly needing to cleanse data from various data providers. I came from an Oracle based tech company and one thing I really miss is the use of regular expressions within SQL statements. For example, Oracle has the regexp_replace function which is very powerful. I know there are functions in SQL like PATINDEX but it's nowhere near as powerful. Is there possiblity of getting this available in SQL server?
Eric Melcher commented
In legacy SQL environments, this could be done using a CLR. However, with Azure SQL, this is no longer an option. There is no feasible way to achieve REGEX in Azure SQL. This needs to be addressed by adding REGEX capabilities natively into T-SQL.