In this series at Part 1 Removing unwanted characters , I posted a method that used a function. In part 2 I posted a method that used Dynamic SQL.

Here is another improved method that uses Dynamic SQL

--Create test data

create table #data (data varchar(100))

insert #data 
select 'tes^@&t %stri)-n!g' data union all
select '))aaer***********)' union all
select '&^&&hsdf()' union all
select 'jj&wk' union all
select ')hw*pa' union all
select 'No&@#$53*24,Mai()$n R--!oad'

--Create table that has all set of characters to be removed

create table clean_chars (char_id int identity(1,1),chars char(1))

insert into clean_chars (chars)
select '^' as repl union all 
select ')' union all
select '(' union all
select '&' union all
select '*' union all
select '%' union all
select '@' union all
select '-' union all
select ',' union all
select '#' union all
select '$' union all
select '#' union all
select '!' 

 declare @sql varchar(max), @select varchar(max)
 select @sql='',@select=''
 select @select=@select+'replace(', @sql=@sql+','''+chars+''','''')' from clean_chars

 select @select='select data,'+@select+'data'+@sql+' as cleaned_data from #data' 
 exec(@select)

The result is

data                                cleaned_data
--------------------------------------------------------
tes^@&t %stri)-n!g                  test string
))aaer***********)                  aaer
&^&&hsdf()                          hsdf
jj&wk                               jjwk
)hw*pa                              hwpa
No&@#$53*24,Mai()$n R--!oad         No5324Main Road