REPLACE ALL FUN with RegEx (in SQL Server Management Studio)

Replace All can be an awful lot of fun in SSMS, but have you tried Regular Expressions? This is a quick little introduction to using RegEx on your SQL code. Edit badly formatted code! Change SELECTs to UPDATEs! Indent all the things! These are simple examples in this video, but there are 1,001 uses for RegEx in SSMS.