>SIN(Pi()/180*Latitude)) + (COS(Pi()/180*#Attributes.OriginLatitude#) *
>COS(Pi()/180*Latitude) * COS(Pi()/180*ABS(#Attributes.OriginLongitude# -
>Longitude))))) * 69.11) AS Distance
>FROM ZipCodes
>WHERE (180/Pi() * (ACOS ((SIN(Pi()/180*#Attributes.OriginLatitude#) *
>SIN(Pi()/180*Latitude)) + (COS(Pi()/180*#Attributes.OriginLatitude#) *
>COS(Pi()/180*Latitude) * COS(Pi()/180*ABS(#Attributes.OriginLongitude# -
>Longitude))))) * 69.11) <= #Attributes.Radius#
>ORDER BY Distance
Hrmmm. THAT probably explains why MapQuest _insists_ that I live at a Fish
Hatchery. :)
--min
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
