Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Storing phone numbers
Message
From
19/10/2010 12:43:21
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Storing phone numbers
Miscellaneous
Thread ID:
01486152
Message ID:
01486152
Views:
114
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!
Very fitting: http://xkcd.com/386/
Next
Reply
Map
View

Click here to load this message in the networking platform