d

DECLARE @dATA AS TABLE (data nvarchar(max))

​

INSERT INTO @dATA

SELECT '##EmploymentStatus## = ''TERMINATED W/ BENEFITS'' and ##UserDefinedField5## = null or ##UserDefinedField5## = ''N'' or ##UserDefinedField5## = ''NO'''

​

SELECT data,REPLACE(REPLACE(data,'## =',' = '),'##','eed_') AS Result

FROM @dATA

  
data
Result

1
##EmploymentStatus## = 'TERMINATED W/ BENEFITS' and ##UserDefinedField5## = null or ##UserDefinedField5## = 'N' or ##UserDefinedField5## = 'NO'
eed_EmploymentStatus =  'TERMINATED W/ BENEFITS' and eed_UserDefinedField5 =  null or eed_UserDefinedField5 =  'N' or eed_UserDefinedField5 =  'NO'