Update query: Editing phone number fields?
I have a problem that a simple update string should fix though i am not familiar with the syntax. I have fields full of phone numbers that i need to do two things to:
1. remove the first digit of the area code
2. add an international calling code
So a number like "02-8765-7464" needs to become "0011-61-2-8765-7464".
At first i tried an update string that updated the code by counting from the right, but some numbers have different amount of digits! So please if you can suggest a way from the left to remove the first digit and add in "0011-61-" id appreciate :)