Leah
4Penny.net
Points: 7116

8/17/2017 3:48:16 PM

ddf_RegexReplace - Regex Replace function for SQL

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu

https://www.red-gate.com/simple-talk/sql/t-sql-programming/tsql-regular-expression-workbench/#fourth

I find myself continually doing a 'we're not worthy' bow to the people at www.red-gate.com. Below is their Regex.Replace function for SQL, it works GREAT. 

I copy it here because it's easier to find when I'm in a hurry... I use this site all day long in production coding. 

RedGate, you rock. 

4Penny.net
Version: All
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3