Best way to store phone numbers?

[StargazeR82]

I defined my phone number fields as varchar(15). If I punch in a number such as 2055576879, then this works fine. If I punch it in as 205-557-6879, then it performs subtraction for the dashes and comes up with a negative four digit number. I wasn't aware that this was possible in a varchar field. Should I store the different parts of the phone number in different fields? Your help is much appreciated.

 

[sleipnir214]

When you perform the insert query, are you using:

insert into foo set phone = 205-557-6879

or

insert into foo set phone = '205-557-6879' Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!