Re: Scanning for similar cities

[Alan Shore <AlanShore@xxxxxxxx>]

Steema - rather than using city, would zip code be more accurate?
Could you not build a file containing city and county tax codes based upon
zip code?



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx


                                                                       
             steema@diskhaven.                                         
             com                                                       
             Sent by:                                                   To
             rpg400-l-bounces@         "RPG programming on the AS400 / 
             midrange.com              iSeries" <rpg400-l@xxxxxxxxxxxx>
                                                                        cc
                                                                       
             03/31/2006 12:23                                      Subject
             PM                        Scanning for similar cities     
                                                                       
                                                                       
             Please respond to                                         
              RPG programming                                          
              on the AS400 /                                           
                  iSeries                                              
             <rpg400-l@midrang                                         
                  e.com>                                               
                                                                       
                                                                       




OK this one is a bit wierd.

We get some web orders and the city field is sometimes including the
county, e.g. there is Houston, there is Houston Harrison. The harder cases
might be for a city that is made up of 2 names to being w/ such as San
Antonio.  I built a logical by city but in some cases it gets subdivided.

The only issue is, how does the program know that there is a problem?

The need is for summarizing state taxes, for those of you familiar, Texas
has separate tax codes by city and county.

The user does her tallying by city tho.
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.