Using lat and long for getting distance works, and there is a site (can not remember where i found it) where you can get all lat and long coordinates for zipcodes. I just googled and found it.

Works great in our situation, we have certain addresses that we are unable to determine the lat and long coordinates so when that happens, we just use the coordinates for the zip code to determine distance.



>I'm working on a program where a user wants to enter a town into the system and receive a listing of records based upon 20 miles or so (user configurable) radius of that zip code. I assume(?) there is a logical layout to zip codes to make this possible as I see it on websites all the time. Has anyone worked out a procedure or resources to accomplish this?
>
>Example: enter Denver, CO
>returns: all records for Denver, nearby Aurora, Centennial, Englewood, etc.
>
>
>If there's a plugin that accomplishes this that could be embedded in VFP, that would work too.
>
>Thanks in advance.
>
>Steve Howie, owner
>DaSH Technology, LLC