RE: US Zip codes

Thanks Booth for taking no offense, for none was intended and all I can
say is ARGHHHHHH. When you mentioned 1983 I KNEW what was coming before
I read the combo deal because I encountered that years ago too. Good
luck !

Chuck

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Booth Martin
Sent: Saturday, October 04, 2003 10:46 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: US Zip codes


Its not a stupid question at all.  



The application was installed prior to 1983.  For whatever reason they
made city & state one field.  Zip code is accurate, but the city & state
have no pattern.  State is quite often 2 letters, but just as often its
the old abbreviations, or spelled out completely.  This is one of those
delicate matters of balance.  Where does one stop in modifying code this
old?  For example these are program described files.  Modifying a file
is a major undertaking.

 

 

 

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

Booth Martin   http://www.MartinVT.com

Booth@xxxxxxxxxxxx

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

 

-------Original Message-------

 

From: Midrange Systems Technical Discussion

Date: Saturday, October 04, 2003 21:26:46

To: 'Midrange Systems Technical Discussion'

Subject: RE: US Zip codes

 

Booth,

 

Stupid question but don't you have a state field in each customer record

?

 

Chuck
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.