Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gayathris
Starting Member
11 Posts |
 Posted - 2012-05-23 : 08:38:24
|
| I have designed a polygon and used this sql query to get the coordinates of the polygon.select ASTEXT(polygon) AS polygon from table_name;Now I want to parse them. I want to seperate the latitude and the longitude .How should I do it? |
|
|
Grifter
Constraint Violating Yak Guru
274 Posts |
Posted - 2012-05-23 : 09:08:22
|
| I think you need to find what is seperating the coordinates and use that to split them. If you can show some of the data in a table view as you see it then it will give people a better idea of how you can do it.G |
 |
|
|
gayathris
Starting Member
11 Posts |
Posted - 2012-05-23 : 09:17:15
|
| I have designed a triangle(closed polygon).I have the points as (9.1234 7.3456,12.4567 14.5678,16.5637 18.4567,9.1234 7.3456).The latitude and the longitude are seperated by a space while the points are seperated by a comma. |
|
|
|
|
|
|
SQL query