|
|
Posted by Faree on 10/25/05 16:11
Oli Filth wrote:
> Faree wrote:
> > yes i am storign that value in a int type column.
> >
>
> Well that's your problem then.
>
> If you insert 001234 into an int type, it stores 1234, because that's
> the integer value.
>
> You'll want to use a character-based type, e.g. VARCHAR(x).
>
> --
> Oli
No Oli..
My problem was when i store actual phone number like 234567
...then also it is storign this number.Thanks for the quick reply.
Regards,
Faree
Navigation:
[Reply to this message]
|