Hoping someone can help with a query I'm stuck on.
I've got a field (sm_contact1number) containing phone numbers. Some of the data has been imported via Excel and its stripped some of the 0's out of the start of telephone numbers, so 0121 3324234 now looks like 121 3324234.. There are also mobile numbers with the same problem.
Can anyone help me out with how I can update:
Numbers starting with a 1 have a 0 added at the front
Numbers strting with a 7 have a 0 added at the front
.. for that field. Also, I'm pretty sure I can narrow down this problem to a specific number of records (eg 100-441) - is there any way I can add that into the query?