Adding a 0

[KristenL]

Hello-



I have a list of zip codes that are missing the beginning 0 is there away to quickly add the missing 0 to the list? I use equals ???? to pull all zip codes up that are only 4 digits long.

[JoeM]

If your field is not of the String/Text data type, but rather a numeric data type, the zero will always be dropped.
However, you can convert it to Text for calculations or display purposes like this:
FORMAT([ZipCode],"00000")
where "ZipCode" is the name of your Zip Code field

[JoeM]

How was this post not helpful to you? Are you not sure how to implement it?

Can you explain your situation a little bit more? What is the data type of your zip code field? How is it being populated with data?

What exactly is your end goal here, are you producing a report, a data extract, etc?

If you provide more details, we can tailor a response to suit your needs.