Thanks for the help, All seems to be working ok with a varchar.
"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message
news:uu1p79ux8.fsf_at_rcn.com...
> On Thu, 16 May 2002, asmithster_at_hotmail.com wrote:
> >
> > I still cannot find a way of inserting a telephone number beginning
> > with a zero.
>
> SQL>create table t1 (fld1 number);
>
> Table created.
>
> SQL>insert into t1 values (01);
>
> 1 row created.
>
> SQL>select * from t1;
>
> FLD1
> ----------
> 1
>
> Is this what is happening? You are losing the leading 0? Then, you
> need to make this column a varchar2, cause a phone-number really isn't a
> number in the datatype sense. It only has the word number in its name.
>
>
> > I have used a 'number' for the variable but each time I enter a number
> > which starts with zero it only displays the next number.
>
> Can you explain what you mean here?
>
> --
> Galen deForest Boyer
> Sweet dreams and flying machines in pieces on the ground.
Received on Fri May 17 2002 - 08:27:20 CDT
