>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!


You'll need a longer space for starts.

My local number would be 08889934046 (I've changed some digits as its an example) so thats 11

my land line would be 02088864020 also 11.