C
CH
I'm trying to update a number field with numbers that have dashes in them.
For example: I'd like to change 620-46-3 to 620463. I know this can be done
with Find and Replace, but I have over 10,000 entries so I'm looking for
another way. Does anyone know what command to use in a query to be able to
take out the dashes for many different numbers? Thanks.
For example: I'd like to change 620-46-3 to 620463. I know this can be done
with Find and Replace, but I have over 10,000 entries so I'm looking for
another way. Does anyone know what command to use in a query to be able to
take out the dashes for many different numbers? Thanks.