title: How can I return a substring of a LINESTRING in SQL Server 2008 Spatial?
body: <p>Say I have a LINESTRING defined as</p>
  
  <pre><code>LINESTRING(-122.360 47.656, -122.343 47.656, -122.310 47.690, -122.310 47.670, -122.300 47.630)
  </code></pre>
  
  <p>And I want to get a substring from</p>
  
  <pre><code>POINT(-122.360 47.656) to POINT(-122.310 47.690)
  </code></pre>
  
  <p>How can I return a substring of a LINESTRING in SQL Server 2008 Spatial?</p>