Unanswered: Strip unwanted characters from phone no in Informix DB
I need to remove any quotation marks from a phone no ie: (,),- field. The phone numbers are in the database as a string. I need to end up with only 10 numbers, then format this field as 999-999-9999 deleting anything that does not match. Please help I am a novice in SQL.