>>>>Hello,
>>>>I am currently working on cleansing some horrific data. I need to store phone numbers (US and international). I usually use a 10 char field and strip out all special characters on the application side for US phone numbers. I've never worked with international phone numbers before. What's a good standard way of storing them?
>>>>
>>>>Thanks!
>>>
>>>I store telephone numbers in a string (20 char). And I have an additional column, BIT, that allows user to specify if the number is International. So I show the telephone number and next to it a check box captioned "[ ] International" If the International check box is not checked I apply the US telephone mask to the telephone field (999-999-9999). Otherwise, if the International is checked, I allow user to enter the number without the mask.
>>>
>>>HTH.
>>
>>This seems like it would fit well. Do you use the same 999-999-9999 format for Canadian?
>
>No. Maybe I am wrong but I am not sure if all Canada uses the same format. So I leave it as International.
Nice, thanks!