I have table with character field (size 15)

for example: 0719996-0001/71

Now I realized that this field must be numeric not character
I have many users

I will send all users the new software where the table contains
the same field as numeric

I need:

If the field type is character, replace all them
with only numbers

so: 0719996-0001/71 will be 0719996000171

This is an import wizard I will create

Notice that in the future I will have users whose software still contain
character field type and other users not

So I have to check the field type before conversion

Moises