Thread: zerofill: lost my leading zeroes

ugh,
I created an integer  column to hold zip codes and
forgot that some US states have zips that start with zeroes.
ie 03455 in new England. There is no zerofill option for
the integer data type is there?
Vincent

On Wed, Mar 20, 2002 at 01:41:46PM -0500,
  Vincent Stoessel <vincent@xaymaca.com> wrote:
> ugh,
> I created an integer  column to hold zip codes and
> forgot that some US states have zips that start with zeroes.
> ie 03455 in new England. There is no zerofill option for
> the integer data type is there?

Either you want to store the zip code as a string instead of a number
or when you print out the number you want to use to_char using a format
of '00000'.

Thanks, I understand now.

Bruno Wolff III wrote:
> On Wed, Mar 20, 2002 at 01:41:46PM -0500,
>   Vincent Stoessel <vincent@xaymaca.com> wrote:
>
>>ugh,
>>I created an integer  column to hold zip codes and
>>forgot that some US states have zips that start with zeroes.
>>ie 03455 in new England. There is no zerofill option for
>>the integer data type is there?
>
>
> Either you want to store the zip code as a string instead of a number
> or when you print out the number you want to use to_char using a format
> of '00000'.