Regular Expression Replace function | Microsoft Connect

Hi, Thanks for your feedback. Your scenario is an excellent example of a UDF that can be implemented using the .NET Framework RegEx Libraries and created as a SQLCLR function instead. This will allow you to move away from the deprecated OLE automation ...

connect.microsoft.com