table that stores zip codes. When we import the zip codes leading and
trailing zeros drop off when inserted, for example: 07080 will become 708. I
thought what if I increased the field length from 10 to 12 (for zip-4), and
for the insert I could add a leading and trailing space like this ' 07080 ',
and guess what? The zeros did not get dropped. I thought what a stupid fix!
What have others done to get around Microsoft telling me I don't need the
zeros?
Thanks, Stan
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
