views:

36

answers:

2

Possible Duplicate:
What datatype should be used for storing phone numbers in SQL Server 2005?

There are various datatypes from which i can choose for example varchar or bigint or decimal or money but which one could be the best in all respect.

+1  A: 

This exact question has been asked before. See this post.

mcass20
These types of posts should be comments, not replies to the thread.
Joe
Oops! Thanks Joe!
mcass20
A: 

VARCHAR - a telephone number is a highly geographically-specific data item, and may typically contain brackets, hyphens, or letters as well as numeric digits.

Jonners