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