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'.