create table #replace(val char(1))
insert into #replace values('_')
insert into #replace values('-')
insert into #replace values('a')
insert into #replace values('b')
insert into #replace values('c')
insert into #replace values('d')
insert into #replace values('e')
insert into #replace values('f')
insert into #replace values('g')
insert into #replace values('h')
insert into #replace values('i')
insert into #replace values('j')
insert into #replace values('k')
insert into #replace values('l')
insert into #replace values('m')
insert into #replace values('n')
insert into #replace values('o')
insert into #replace values('p')
insert into #replace values('q')
insert into #replace values('r')
insert into #replace values('s')
insert into #replace values('t')
insert into #replace values('u')
insert into #replace values('v')
insert into #replace values('w')
insert into #replace values('x')
insert into #replace values('y')
insert into #replace values('z')
declare @tmp varchar(100)
select @tmp = '-_abcdefghijklmnopqrstuvwxyz0123456789'
select @tmp = replace(@tmp, val, '') from #replace
select @tmp
drop table #replace