SELECT * FROM MyTable AS T WHERE TRY_CONVERT(INT, T.MyColumn) IS NULL

SELECT * FROM MyTable AS T WHERE T.MyColumn NOT LIKE '%^[0-9]%'