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