General information
Category:
Coding, syntax & commands
Title:
Character to numeric conversion
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only