LEADING O'S IN ZIP CODES

[fishma]

What does your concatenation definition look like?

Fishma...

[Chuck]

It sounds like either the zip code field is a number field, or that somewhere in your calculations it's being converted from text to a number.

If you zip code field is a number field, make it a text field. You shouldn't loose any data, but it won't loose the leading zero either. Zip codes are more properly text fields anyway, since they aren't really representing a numeric quantity, and sometimes (as with Canadian postal codes or with zip+4 codes) they need to have text elements in them.

Try that and see if it fixes your problem. If not, then you might be converting the text field to a number field somewhere. Check for this if the first solution fails.

Chuck

[NICSTEF]

I've been using filemaker for 8 years and for the first time have a customer with a zip that starts with 0. I have a concatenation field that bring city, state and zip together but it drops the leading zero. It's entered in the customer data base as 03689 but when it concatenates it's just 3689. Any one know how to fix this?

Nick

[NICSTEF]

quote:

---

Originally posted by fishma:

What does your concatenation definition look like?

Fishma...

---

Another response suggested changing the zip field to text instead of number. I did that and it worked. Thanks.

Nick