[AccessD] Update Query: Remove Hyphens in Phone Number

Gale Perez galeper at gmail.com
Thu Aug 9 17:19:32 CDT 2007


Hi!

I'm creating a new phone number field with a phone number input mask, to
replace a text field with actual hyphens in the numbers.  Has anyone done an
update query which copy the digits only from the old field to the new field
(or which would just strip them and leave the digits in the current field)?

Thank you,
Gale



More information about the AccessD mailing list