I need to save contact information in a table. Which datatype should I use, please advise. Wait. Please continue reading before responding.
Given that sales representatives can utilize this field for searches, it needs to be heavily indexed (including wild character search).
We currently anticipate that phone numbers will come in a variety of formats (from an XML file). To convert to a standard format, do I need to develop a parser? It's possible that there may be millions of data (many of which will be duplicates), and I don't want to use up too many server resources on preprocessing each time any new source data is received.\
Can someone please help me with this?