OT- sql format question

[Eric Creese]

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
FROM zipCodes
WHERE (((Sqr(((69.1*(CDbl(zipCodes.Latitude)-39.166759))^2)+((69.1*(CDbl(zipCodes.Longitude)-84.53822)*Cos(39.166759/57.3))^2)))<50));

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---