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?


update customer
set phone=("999"+ ','+'phone)
where phone ?

Any help will be greatly appreciated.

__________________
Jaime E. Maccou

I am not certain what data type your telephone column is but SQL has this cool function called STUFF that might be useful to you in this situation because it will count characters in a string and do inserts and deletes. I can see a script that could be programmed that counts the string lenght to determine if it needed an update or didn't need an update. The ones needing an update would be parsed from the others then the proper digits would be stuffed into the field in their proper places. I hope this is of some help ?? Jim

where len(phone)=7

Thank you very much, right on time

My results

update customer
set phone='999'+phone
where len(phone)=7