My last post included a 200 mile radius. Just change the 200(s) to 50
for a 50 mile radius.
Christian
-----Original Message-----
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Friday, August 13, 2004 2:02 PM
To: CF-Talk
Subject: RE: OT- sql format question
OOOPs it looks like I forgot to paste the rest:
WHERE
(((Square(((69.1*(CDbl(zipCodes.Latitude)-39.166759))^2)+((69.1*(CDbl(zi
pCodes.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(zipCode
s.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]
- OT- sql format question Eric Creese
- Re: OT- sql format question Phillip Beazley
- RE: OT- sql format question Eric Creese
- RE: OT- sql format question Phillip Beazley
- RE: OT- sql format question Christian Watt
- RE: OT- sql format question Christian Watt
- RE: OT- sql format question Eric Creese
- RE: OT- sql format question Christian Watt
- RE: OT- sql format question Eric Creese