Scott Purcell wrote:
>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 numbe
Hello. I posted a similar question a while back and received a bunch of
responses. It depends on how you plan to use the numbers. If you plan to
use them in calculations, then storing them as INTs is best. Also,
breaking a number into separate components makes sense if you plan to use
these compone
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 ad