Hi Rajesh
My solution has been, after much thought, to NOT format it. Even if you specify all digits, what about those cell and US numbers that include the letters, like "349 WALK" for a dog-walking company. You can UPPER() any letters input, later validate for only numeric, alpha or "-".
>Hi Terry
>
>You have a valid point here! What is solution to this in your opinion. Should we store formatting characters as a part of phone no. in the database or something else ?
>
>Rajesh
>>Rajesh
>>
>>Just a little note of caution when formatting phone no. fields....>
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.