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

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