What datatype should be used for storing phone numbers in SQL Server 2005

0 votes
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?
Sep 10 in Database by Kithuzzz
• 11,640 points
13 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Database

0 votes
1 answer

What are the different authentication modes in SQL Server? How can it be changed?

Windows mode and Mixed Mode – SQL ...READ MORE

answered Oct 29, 2018 in Database by Sahiti
• 6,380 points
646 views
0 votes
0 answers

Which SQL server should we use for SQL queries to be executed?

I mean to say which SQL server ...READ MORE

Aug 18, 2019 in Database by Sonali
223 views
0 votes
1 answer

SQL Server replaces LEFT JOIN for LEFT OUTER JOIN in view query

You are getting the joins confused and ...READ MORE

answered Feb 4 in Database by Neha
• 8,920 points
183 views
0 votes
1 answer

How Can I use "Date" Datatype in sql server?

There's problem in all of them and ...READ MORE

answered Feb 9 in Database by Neha
• 8,920 points
161 views
0 votes
1 answer

Should I use != or <> for not equal in T-SQL?

Most of the existing databases support != Databases that ...READ MORE

answered Feb 14 in Database by Vaani
• 7,020 points
59 views
0 votes
1 answer

Syntax of for-loop in SQL Server

TSQL has no for-loop, we have only ...READ MORE

answered Feb 15 in Database by Neha
• 8,920 points
111 views
0 votes
1 answer
0 votes
0 answers

What are Covering Indexes and Covered Queries in SQL Server?

Can you describe the ideas behind Covering ...READ MORE

Aug 21 in Database by Kithuzzz
• 11,640 points
21 views
0 votes
1 answer

How to find index from raw and column in python?

You probably want to use np.ravel_multi_index: import numpy as ...READ MORE

answered Sep 12, 2018 in Python by Priyaj
• 58,080 points
410 views
0 votes
1 answer

How to find index from raw and column in python?

You probably want to use np.ravel_multi_index: import numpy as ...READ MORE

answered Sep 24, 2018 in Python by Priyaj
• 58,080 points
528 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP