On Wed, Mar 20, 2002 at 01:41:46PM -0500,
Vincent Stoessel <vincent(at)xaymaca(dot)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'.