[Manifold-l] Distance calculations

[Simon Linder]

Is there anyway to just input the lat long of the store as the second point?
How do you insert a lat long in a query like this?

Simon Linder
Wider Networks
slinder at widernetworks.com
(w) 301.951.2767
(m) 301.768.9170

-----Original Message-----
From: manifold-l-bounces at lists.directionsmag.com
[mailto:manifold-l-bounces at lists.directionsmag.com] On Behalf Of Bob
Heitzman
Sent: Friday, September 15, 2006 2:06 PM
To: slinder at widernetworks.com
Cc: manifold-l at lists.directionsmag.com
Subject: Re: [Manifold-l] Distance calculations

Assuming the geocoded list is a drawing [A]:

SELECT [Customer_Data],
FormatNumber(
Distance
(
  [ID],
  (
   SELECT [ID]
   FROM [Stores]
   WHERE [Store]='Acme Shoes'
   )
   ,'mi'
)
,1)
FROM [A]

In essence Distance(pt1,pt2,units).

See Spatial Extensions and SQL Reserved Words/Index help topics.
_______________________________________________
Manifold-l mailing list
Manifold-l at lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/manifold-l

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.12.4/448 - Release Date: 9/14/2006
 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.12.4/448 - Release Date: 9/14/2006