Zip codes difference

Hello,

I have a database which has listing of canadian users. What is the best way show like users in 10, 15, 20, 02 30 miles radius after user enters the zip code in a search screen? How to find out which zip code is nearer to the zip code which user enters in a search screen? The database has data like user address including the zip codes.

Any one has developed this kind of functionality?

Thanks

MS

Subject: Zip codes difference

Try this:

http://www.emory.com/progress/canada.htm

There are other similar commercial solutions out there, all working on the same principal – a database of Postal Codes (ZIP is an American thing) along with a latitude & longitude. You enter the “home” Postal Code and a radius, and the software returns all of the Postal Codes within the radius. You then compare that list against the Postal Codes in your database (office/store locations, etc.) and return the related documents.

Subject: RE: Zip codes difference

Thanks

MS