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

• Messages sorted by: [ date ][ thread ][ subject ][ author ]
• Previous message: Danny Sinang: "[Emerald] Security config in Emerald Admin not working ?"
• Next message: Josh Hillman: "[Emerald] Calls table entries"
• Next in thread: Dan Tang: "Re: [Emerald] SQL QUERY: Extracting Spaces and/or '-' from Phone Numbers"

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:
http://www.iea-software.com/support/maillists/liststart

• Previous message: Danny Sinang: "[Emerald] Security config in Emerald Admin not working ?"
• Next message: Josh Hillman: "[Emerald] Calls table entries"
• Next in thread: Dan Tang: "Re: [Emerald] SQL QUERY: Extracting Spaces and/or '-' from Phone Numbers"