How often have you opened your customer database and spent hours cleaning and formatting phone numbers? It is the most common problem hampering the efficiency of your business. Yet, many companies still ignore them and end up collecting invalid or duplicate data.
At the heart of this problem, lies a simple question - should you store a phone number as an integer or as a string in a database. But, the Internet forums are divided on this topic leading to confusion. Most of these arguments are one dimensional and ignores the real challenges behind storing phone numbers.