[Emerald] SQL QUERY: Extracting Spaces and/or '-' from Phone Numbers

Rudy Komsic ( (no email) )
Sat, 5 Feb 2000 06:23:31 -0500


I am not a SQL Guru but I would like to be able to remove all hyphens and/or
spaces from the phone numbers cause we would like to create some ANI
Checking vs the Phone list to allow clients to change their passwords and/or
access their account info.

So if someone's Home phone number is 123 345-5678, I would like to be able
to rewrite that in a stored procedure which would run nightly to rewrite all
phone numbers in ANI compatible format "1233455678"

Any suggestions on this one?

For more information about this list (including removal) go to: