>>Hi everyone,
>>
>>Do you know, where can I download a file with ZIPCODES in each town in US? I have a table called ZIP_5 with this structure:
>>

>>CityName  C(28)
>>State     C(2)
>>ZipCode   C(5)
>>AreaCode  C(3)
>>CountyFips C(3)
>>CountyName C(25)
>>PrefCode   C(1)

>>It has 73703 records.
>>
>>I don't remember, how we populated it the first time, but I found, that the info here is old, so we need to re-download it.
>>
>>Thanks in advance.
>
>Nadya,
>
>If it's available, I'd use MapPoint as an automation server and by-pass the table altogether. I don't have the code handy, but you can provide it with a street address, city and state and it can give you the zip code.

Hi George,

I'm not sure, I understand your point. We're doing Address Standardization for Owner addresses. The owner of the property could be from any state of US (and even non-US). As the first step I check for validity State+Zip+City combination and report, if it's wrong. Since we have old data in the Zip_5 table, perfectly valid records were reported wrongly as invalid.