7 Digit number
I have a customer table which contains phone numbers some have area codes and some do not. I want to be able to update [u]only</u>customer with 7 digits only (ex: 1234567) not the ones with area code (Ex:9991234567). how can I go about doing this?
set phone=("999"+ ','+'phone)
where phone ?
Any help will be greatly appreciated.
Jaime E. Maccou