[AccessD] Update Query: Remove Hyphens in Phone Number

LOL  Welcome to the club!  I've been feeling foolish for years!

Charlotte 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gale Perez
Sent: Monday, August 13, 2007 2:27 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Update Query: Remove Hyphens in Phone Number

Thank you, Charlotte (boy, do I feel foolish ... happens a lot these
days)!

Gale


On 8/9/07, Charlotte Foust <cfoust at infostatsystems.com> wrote:
>
> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com