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?