CODE EXAMPLE FOR SQL

sql where is not number

SELECT CustomerId FROM CUSTOMER_TABLE 
WHERE CustomerId ISNUMERIC(CustomerId) = 0

-- if you want to get only number try to change 0 to 1