title: SQL Server 2008 GEOGRAPHY STDistance() value
body: <p>I am using geography.STDistance() to return the distance between two single point locations. I'm curious as to which measurement is used for the return value? Is it in KM's, miles or perhaps some other?</p>
  
  <p>I'm getting results back upwards of 250k but i've no idea if im doing something wrong with my TSQL as these are historical locations(i.e. they no longer exist) so I can't just do a quick lookup.</p>
  
  <pre><code>declare @p1 geography
  
  declare @p2 geography
  
  SELECT @p1 = Location from tblLocations where Id = 1
  SELECT @p2 = Location from tblLocations where Id = 2
  
  select @p1.STDistance(@p2)
  </code></pre>