CODEWITHSUNDEEP
sql-server-2008
Nik
Nik

Reputation: 7273

SQL Server 2008 SQL Spatial LINESTRING Manipulation

I have a LINESTRING stored in my table and I need to know at what end of the string a point lies on. The idea is that I need to know what "direction" the LINESTRING was defined in so that I can calculate a distance down the line in the appropriate manner (which I already know how to do). Anybody have any ideas? Thanks in advance.

Upvotes: 1

Views: 338

Answers (1)

Nik
Nik

Reputation: 7273

I came across the answer. STStartPoint() and STEndPoint() are functions you can call on a LINESTRING instance to get POINT objects representing what the function names imply.

Upvotes: 1

Related Questions