pls check below code:

declare @t1 table(id int,name varchar(10))

insert into @t1(id,name) values(1,'1'),(2,'2'),(3,'4'),(4,'7'),(5,'8_'),(9,'9'),(10,'0')

select id,CONVERT(int,replace(name,'_','')) from @t1

--CONVERT(int,replace(name,'_','')) from @t1

where name like '%[^0_9]%'

here name will come between 0 and 9 (zero,nine related records will not come)