G
Guest
Is there a function that will allow me to only pull the numeric data from a
field? Currently I have a field with letters and numbers, but I want to
isolate the numbers.
Current field How I want it
530146374D 530146374
ABFS004163635 4163635
AD43285 43285
151652777 151652777
I have tried using the built in functions (left, right, mid, etc. ) in a
query, but have had little success because there are so many formats to the
current field. Is there a simple fuction that just looks at the numbers and
ignores all letters? If one does not exist, would it be possible to create a
function that will perform this task?
field? Currently I have a field with letters and numbers, but I want to
isolate the numbers.
Current field How I want it
530146374D 530146374
ABFS004163635 4163635
AD43285 43285
151652777 151652777
I have tried using the built in functions (left, right, mid, etc. ) in a
query, but have had little success because there are so many formats to the
current field. Is there a simple fuction that just looks at the numbers and
ignores all letters? If one does not exist, would it be possible to create a
function that will perform this task?