SELECT COLUMNNAME FROM TABLENAME WHERE ISNUMERIC(COLUMNNAME)=1

use isnumeric() inbuild function