format telephone fax ia a table
Ade2Jan 3 2007 — edited Jan 3 2007have a table contact info with contact_tel, contact_fax etc. The contact_tel, contact_fax are inputted without formating, some are null example
Contact_tel contact Fax
------------------------ ---------------------
111-463-8277 111-463-8277
111-1111 111-1111
1111111111 1111111111
Null null
(111) 111-1111 (111) 111-1111
The requirement is to update the table and make all the contact_tel and contact fax in this format (111) 111-1111.
Any sugggestion will be appreciated.