Thanks Al,

I'll give it a shot!

John

>>>>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 )
>
>* Maths as per Google link(s)
>...
>
>RETURN Distance
>