Field Substring Character Removal 1

[Omnillas]

I have taken over a database that has some not-so-normalized data in a field that contains phone numbers.

Some fields are all numeric and some have the dashes. What's a good method for removing the dash character? I have looked at a couple substring functions but I need something tiny and efficient. Anyone have a good suggestion for an effective and efficient removal of substring characters?

 

[EBGreen]

Replace(strText, "-", "")

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[lupins46]

Do you want to remove the dashes and leave the space or do you want to modify the value so that it is a continuous string of numbers with no spaces?

 

[Omnillas]

I would like to eliminate the dash and replace with nothing in effect closing the resulting string up.

Looking for a good update query method to performing the adjustments.

 

[Omnillas]

I did a better search this time in Tek-Tips and found out my issue is really limited to Access 97.

http://www.tek-tips.com/viewthread.cfm?qid=492699