>If I have the latitude and longitude of areas by zip code, how can I find the list of all items that fall within an X mile radius?
SELECT ;
Areas.Name ;
FROM Areas ;
WHERE RadiusFunc(Areas.Lat, Areas.Long, TestLat, TestLong) <= X ;
...
You can develop RadiusFunc from the formulae at
http://www.mathforum.com/library/drmath/view/51711.html
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up