From: Hank Date: October 9 2005 3:12pm Subject: Re: Distance between Zip codes List-Archive: http://lists.mysql.com/mysql/190150 Message-Id: <1990a96b0510090812n1c93fc01p4c8e2eb3303adcce@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Don't forget that you're not caclucating "driving distance", but "great circle" distance, which is roughly a straight line over short distances. If you radius is great than, say 50 miles, people might complain that the actual driving distance is much greater than the straight line distance you provided. -- -Hank mysql, query