I have the following column in my table
MobilePhone
----------
+1 647 555 5556
I want to end up with the following format.
Basically removing the '+' sign, the country code '1' and all spaces.
MobilePhone
----------
6475555556
can someone please point to right direction.