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...