avoiding truncating leading zero

[Guest]

How do you prevent the leading zero (in zip codes) from dropping? I am
trying to create a table w/ various zip codes.

 

[kerry_ja]

Have the zip code as text, not a number

 

[Wayne Morgan]

The easiest way is by making the field a text field instead of a number
field.

 

[Joseph Meehan]

How do you prevent the leading zero (in zip codes) from dropping? I
am trying to create a table w/ various zip codes.

Use number only when you need to use them in calculations or to sort
them when there may not be leading zeros with the same total number of
characters.

Since zip codes are not calculated, then you will want to use a text
type. If you want to sort them, be sure to include zeros for the plus 4
part as well.

 

[Guest]

Best practices show that Zipcodes are actually Text Fields, Take Canada's
Postal Codes, they have a combination of Numeric and Alpha, which constitutes
it as a Text Filed.