add a leading character

[Kurt Knippel]

quote:

---

Originally posted by ScottHaneda:

I have a DB that has several thousand zip codes in at that lost a leading character...for example, 1568 should be 01568.

Anyone know how I can insert a "0" in front of all of them?

---

Replace (ZipCode, Left("00000" & ZipCode, 5)).

This should give you a 5 char zip code every time, with zeros filling in the missing numbers.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.database-resources.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=

[ScottHaneda]

I have a DB that has several thousand zip codes in at that lost a leading character...for example, 1568 should be 01568.

Anyone know how I can insert a "0" in front of all of them?