>>>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham