Radius search

[John Pearce]

Greetings!

I've been asked to implement a radius search based on Zipcode.  Somdthing
like find all addreses in the database that are within 100 miles of Zipcode
80201.  I located a database of Zipcodes with lattitude & longitude
coordinates and I've found the math to make it work.  The downside is that
the math requires trig functions that don't seem to be within PowerHouse.

I'm wondering if anyone has done this type of thing and how it was done.
If it makes any difference, the platform is HP MPE/iX 5.5 and PH 8.19.

Thanks,

John

------------------------------------------------------------------
John Pearce  <jpearce@rmi.net>	| Bethesda Management Company 
Speaking for only myself		| Colorado Springs, CO  USA
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.