[Manifold-l] Distance calculations

[Bob Heitzman]

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.