I have some zipcodes that are in 5 digits..
the base as in USpS is 5 digit and these zipcodes are assigned to codes
and so on so the default +4 is 9999 for the zipcodes...
Now the assignments is done on 5 digit bases but if their is a 4 digit assigned to someone else from the base 5 that appears as data so example
So the base owner is Q328 but than some of the zips wchich have +4's belong to anoterh code..
Now i need to find the ranges in zip codes
So it should do
zmin zmax code
38170000 381389203 Q238
381389204 381389204 Q104
381389205 381383928 Q328
381043929 381383930 Q104
so the number between i.e the number that is not an exception should get another range and then get assigned to the base owner....
Does someone has any suggestions...