Hi,
> I am waffling on how to handle a column of phone numbers. I am not sure
what is common practice on the database side. Talking to some co-workers,
some feel it would be fine to use a varchar and others think there should be
3 integer columns in the database for each number?
>
> Anyone have advice or know of best-practice on this subject?
Well, there was a long thread on this last week.
Anyway, given that a phone-number IS NOT an integer (eg: leading zeros),
it simply cannot be stored into a numerical column.
Also, these days, you might have character-based phone-numbers:
0800-AOLUSA.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
