I have a database with zipcodes and corresponding latitudes and longitudes. Can anyone suggest a mysql statement that can pull me all zipcodes within 20 or 50 or 100 miles of a given zipcode Kshitij Bedi Web Administrator International Trademark Association