sql

SELECT * from Test
 where  ISNUMERIC(name)<> 1
 
 
 INSERT INTO test(name)
     VALUES('Test1'),
         ('Test2'),
         ('Test3');
         
 SELECT *,patindex('%[^0-9a-zA-Z]%',name) from Test
 where  patindex('%[^0-9a-zA-Z]%',name)>1