I think I may have a solution. I'll let you know if it works. John
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Virgil Bierschwale Sent: Friday, April 27, 2007 8:59 PM To: 'ProFox Email List' Subject: RE: Need a Math Wiz I'd be interested in helping you to map them like I have done here since you have the lat and lng http://www.virgilslist.com/bsolutions_ff1059.asp?state=VA If it will help you and it's not confidential, that is. Virgil Bierschwale Armstrong and Skipper Real Estate (830) 329-6774 Cell (830) 864-4799 Fax (830) 864-4726 Home http://www.bierschwale.com http://www.bierschwalesolutions.com http://www.JobsForOurFuture.com/index.php -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of john harvey Sent: Friday, April 27, 2007 8:57 PM To: 'ProFox Email List' Subject: RE: Need a Math Wiz Aight, I know some o use guyz are math wizzes and I ain't. I am persistent though, and I will gladly use stolen/purloined/borrowed/copied/etc code. I have a table of warrants 55,000+ which I have geocoded. I am testing a system that will push out information, via email, to the neighborhood watch groups, a table of crimes within a 1/2 mile radius, over the past 30 days. That data is already available via a system the MPD has and I'm pushing it to some test users. I want to also add into those emails a listing of warrants within that radius and push it out as well. Therein lies the problem. (I'm afraid I must have been distracted when those classes were taught). Does anyone have a clue how to do a select from a table given a lat and long and select all records that fall within the 1/2 mile radius? Help!!!!!! John Harvey [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@shelbynet.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.