# Find Lat, Long values given STdistance and a point value

• ### Question

• ```DECLARE @pointA geography;
DECLARE @pointB geography;
SET @pointA = geography::Parse('POINT('+ CAST(119.93289251 AS VARCHAR) +' '+ CAST(-22.44282786 AS VARCHAR) +')') ;
SET @pointB = geography::Parse('POINT('+ CAST(119.93289171 AS VARCHAR) +' '+ CAST(-22.44282573 AS VARCHAR) +')') ;
SELECT @pointA.STDistance(@pointB);```

STDistance value between these two points = 0.249830 meters

Given two points like above we can find Spatial distance between them. My question is if I know only one of the above points (ex:pointA) and STDistance value can I find the other point (ex:pointB).

Thank you

Thursday, January 26, 2017 7:56 PM

### All replies

• Hi Sriupp,

I hope you can find a lead from the following link.

Nevertheless, I am looking forward to see a solution posted on this page.

Cheers,

Sunit

Please mark this reply as answer if it solved your issue or vote as helpful if it helped.

Thursday, January 26, 2017 8:28 PM
• Thank you for the link, Sunit
Thursday, January 26, 2017 8:57 PM