WHERE (((Square(((69.1*(CDbl(zipCodes.Latitude)-39.166759))^2)+((69.1*(CDbl(zipCodes.Longitude)-84.53822)*Cos(39.166759/57.3))^2)))<50));
-----Original Message-----
From: Phillip Beazley [mailto:[EMAIL PROTECTED]
Sent: Friday, August 13, 2004 1:58 PM
To: CF-Talk
Subject: Re: OT- sql format question
At 02:38 PM 8/13/2004, you wrote:
>This was written in access, can anyone convert to T-SQL
>I keep doing it and keep missing something.
>
>SELECT zipCodes.*,
>Sqr(((69.1*(CDbl(zipCodes.Latitude)-39.166759))^2)+((69.1*(CDbl(zipCodes.Longitude)-84.53822)*Cos(39.166759/57.3))^2))
>AS DistanceInMiles
Untested but looks good:
SQRT(POWER((69.1*(zipCodes.latitude-39.166759)),2)+POWER((69.1*(zipCodes.longitude-84.53822)*COS(39.166759/57.3)),2)
AS DistanceInMiles
--
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]
