Get only numeric column values SQL

SELECT column1 FROM table WHERE ISNUMERIC(column1) = 1

OR

SELECT column1 FROM table WHERE column1 not like '%[^0-9]%' and column1 != ''