>OOOPs it looks like I forgot to paste the rest:
>
>
>WHERE
>(((Square(((69.1*(CDbl(zipCodes.Latitude)-39.166759))^2)+((69.1*(CDbl(zipCodes.Longitude)-84.53822)*Cos(39.166759/57.3))^2)))<50));
Okay...
WHERE
SQRT(POWER((69.1*(zipCodes.latitude-39.166759)),2)+POWER((69.1*(zipCodes.longitude-84.53822)*COS(39.166759/57.3)),2)
< 50 ;
--
Phillip Beazley
Onvix -- Website Hosting, Development & E-commerce
Visit http://www.onvix.com/ or call 727-578-9600.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
