I have data as followos: Table: contact column: phone as varchar +1 (800) 863-3950 ext. 517 +1.510.291.6100 ext2347 +1.714.545.8886 ext 144 714.545.8887 ext 144 714.545.8898 +1.510.291.6101
I need to extract only the phone numbers using a SQL query like: +1 (800) 863-3950 ext. 517 ------- 8008603950 +1.510.291.6100 ext2347 -------- 5102916100 +1.714.545.8886 ext 144 --------- 7145458886 714.545.8887 ext 144 ----------- 7145458887 714.545.8898 -------------- 7145458898 +1.510.291.6101 ------------- 5102916101 What should be the sql? Any help.
