Is there an easier way to replace?

Question

SQL Server

Have a nice day, everyone!
I have a need to check the value for the presence of characters and if they are in it, then replace them.
Now I do it like this:

select @Name = Name from #T
  set @Name = replace (@Name,'#','_')
  set @Name = replace (@Name,'%','_')
  set @Name = replace (@Name,'&','_')
  set @Name = replace (@Name,'{','_')
  set @Name = replace (@Name,'}','_')
  set @Name = replace (@Name,'\','_')
  set @Name = replace (@Name,'|','_')
  set @Name = replace (@Name,'/','_')
  set @Name = replace (@Name,'>','_')
  set @Name = replace (@Name,'<','_')
  set @Name = replace (@Name,'*','_')
  set @Name = replace (@Name,'?','_')
  set @Name = replace (@Name,'$','_')
  set @Name = replace (@Name,'!','_')
  set @Name = replace (@Name,'''','_')
  set @Name = replace (@Name,'"','_')
  set @Name = replace (@Name,':','_')
  set @Name = replace (@Name,'@','_')
  set @Name = replace (@Name,'+','_')
  set @Name = replace (@Name,'`','_')
  set @Name = replace (@Name,'=','_')
  set @Name = replace (@Name,'-','_')
  set @Name = replace (@Name,'  ',' ')
  set @Name = replace (@Name,'  ',' ')
  set @Name = replace (@Name,'  ',' ')
  set @Name = replace (@Name,char(13),' ')
  set @Name = replace (@Name,char(10),' ')

  select @Name

Maybe there are some easier ways? Any ideas?

Answer 1

Can.
The first option - replace can be nested like functional programming:
It does not look very good, but it can be broken into lines for readability.
The second option is more complicated, but more interesting:

declare @Name varchar(200) = 'abcdefg';

select @Name = replace(@Name, t.c, t.r)
from (
    values ('a','_'),('b','_'),('c','_')
) t(c,r)

print @Name