>>>I have a table of warrants with latitude and longitude, and I would like to be able to select all warrants within a given radius. I know I've seen this discussed before. Any of you math professors got a clue?
>>
>>GIYF:
http://www.google.ca/search?q=lat+long+distance+between+points>
>I didn't see anything about pulling records within a given radius....
To expand on Hilmar's response you could do something like
SELECT ;
... ;
FROM Warrants ;
WHERE DistanceBetween( StationLat, StationLong, WarrantLat, WarrantLong ) <= SomeDistance ;
...
FUNCTION DistanceBetween( StationLat, StationLong, WarrantLat, WarrantLong )
...
RETURN Distance
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