RE: US Zip codes

[Glenn Ericson <Glenn-Ericson@xxxxxxx>]

This is program defined  file you are dealing  with in the 
concatenated  city  state  with no  rules.

Zip  code is not  good  for taxing  jurisdictions  either. There is  a 
statistic out there some  place  that says  this is a real NO NO

At 10:45 PM 10/4/2003 -0500, Booth Martin wrote:
> 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.