Quick suggestion, use the REPLACE function
😎
USE TEEST;
GO
SET NOCOUNT ON;

DECLARE @FOLDER_TO_REPLACE VARCHAR(50) = '\DEF\';

;WITH FilePaths(FilePath) AS
( SELECT FilePath FROM

Quick thought, no need for this complexity in the script, here is a simplified example
😎
declare @myXml xml=N'<MyXML>
  <NewComponents>
   <TopRef locpoint="BSAMMUSA" >242
    <Comps...

One can use the DigitsOnlyEE function for this
😎
USE [TEEST]
GO
SET NOCOUNT ON;
DECLARE @NUMSTRING TABLE (NMSTR VARCHAR(20) NOT NULL);
INSERT INTO @NUMSTRING(NMSTR)
VALUES...

For fun
😎

USE TEEST;
GO
SET NOCOUNT ON;

DECLARE @NUM_QUARTERS INT = 7;
;WITH T(N) AS (SELECT X.N FROM (VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) X(N))
, NUMS(N) AS...

Just piling on, since you are on 2008+ then you can combine the declaration and the assignment into one statement.
😎
declare @scorerecordtype__c varchar(50) = 'batch';
select...

One thought, you could use the Open XML word processing schema, zip it and rename to doc whatever, not a trivial exercise though.
😎

If you know the algorithm used then you could theoretically use a rainbow table to find the original values, somewhat elaborate exercise.
😎

SELECT ? FROM [QA_rowperclient]  is not a valid query
😎

Quick question, why is there no root element in the xml?
😎