How to Remove All Data Except Certain Text from a String Using Regex

Extracting Specific Elements from an XML Document using XQuery in SQL Server 2005 or Later