[AccessD] Update Query: Remove Hyphens in Phone Number

Just use the replace function to replace any instance of "-" with "".

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gale Perez
Sent: Thursday, August 09, 2007 3:20 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Update Query: Remove Hyphens in Phone Number

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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com