How to find Non numerical values in Column using SQL

13.How to find Non numerical values in Column using SQL

CREATE TABLE dbo.NonString
(
ID varchar(25),
StateName Varchar(25)
)

INSERT INTO dbo.NonString VALUES ('123,2', 'TX')
INSERT INTO dbo.NonString VALUES ('500_9', 'CA')
INSERT INTO dbo.NonString VALUES ('145', 'AZ')
INSERT INTO dbo.NonString VALUES ('1245=', 'MD')
INSERT INTO dbo.NonString VALUES ('123,4', 'DC')
INSERT INTO dbo.NonString VALUES ('9000', 'OH')


SELECT * FROM dbo.NonString


SELECT * FROM(
SELECT A.ID , CASE WHEN A.ID NOT LIKE '%[^0-9]%' THEN 'Number Value' ELSE 'String Value' END VALUE_DATA_TYPE
FROM dbo.NonString A WHERE A.ID IS NOT NULL)X
WHERE VALUE_DATA_TYPE='String Value'