Re: phone number list

On 10 Sep 2003, Bryan Irvine wrote:

> I have a db that contains phone numbers
> 
> The data that get inserted looks like this
> 
> 425 555 1212
> 
> I have a script that inserts that into the DB, the problem is that
> sometimes the suffix might start with a 0 and is getting truncated.
> 
> so
> 
> 425 555 0212 
> 
> ends up being
> 
> 425 555  212.  How can I fix this?

You are using a numerical field (or fields) for the number,
when you should be using a string.  For one thing, the 123-4567
or 123-456-7890 numbers are not universal.  The actual format
of the number depends on the locality.

Gord