Anyone on the list have a handy copy of the formula required to find all the zip codes surrounding one Long/Lat location? I already have the Zips DB with long/lat info in it, I just need a quick query or stored proc that will return the radius and all the zips in it. I actually wrote a proc that did this long ago (sometime in 1999 or 2000?), and I might have even posted it to this list, but have since lost it.
Anyone? Thanks! -Cameron ----------------- Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
