removing dashes from a field

[aripie]

I am a newbie at using Access and I need to do some suppressions, but my problem is the master file I am suppressing against the phone field is 333-333-3333 while the other table files are 3333333333.

I am attempting to remove the dashes from the master file with no luck.

Any suggestions? Either through the design view or a straight SQL string?

Any help is appreciated and thanks!

 

[r937]

use the access Replace function

or, if the dashes are always in the same position, use the Mid (substring) function

rudy

http://r937.com/

SQL Consulting

 

[aripie]

Thank you!

In the process I also found another good one that worked miracles:

UPDATE [Table A] SET [phone] = replace([phone],'-','')

Worked like a charm

Thanks again!