title: Moving a Point along a Path in SQL Server 2008
body: <p>I have a geography field stored in my database, holding a linestring path. </p>
  
  <p>I want to move a point <code>n</code> meters along this linestring, and return the destination. </p>
  
  <p>For example, I want the destination point 500 meters along the linestring starting from its beginning.</p>
  
  <p>Here's an example -- what is the <code>YourFunctionHere</code>? Or, is there another way?</p>
  
  <pre><code>DECLARE @g geography;
  SET @g = geography::STGeomFromText('LINESTRING(-122.360 47.656, -122.343 47.656, -122.310 47.690)', 4326);
  SELECT @g.YourFunctionHere(100).ToString();
  </code></pre>