How to extract area code from a 10 digit phone and put in another field in automated fashionReport
Please briefly explain why you feel this question should be reported .
I have a rather large database of phone numbers in 10 digit format. I want to have a field in the database that just holds the prefix [ left(phonefield,3) ]
I can do update table set new-field=left(phone,3) and it will do it to all.
My question is:
Is there any way for this to happen automagically. I.E. as soon as records are imported it would automatically do this vs me doing it manually???