title: SQL Server create centroid of a polygon inside of a polygon
body: <p>I would like to create a centroid of a polygon (type geometry) such that the centroid falls inside of the polygon</p>
  
  <p>I have tried with function shape.STCentroid() which is creating the centroid but for my shape/polygon the centroid is falling outside of the polygon</p>
  
  <p>Spatial result centroid is falling outside of the polygon as polygon is a '&lt;' shaped polygon and centroid looks like '&lt;.' </p>
  
  <p><img src="https://i.stack.imgur.com/uYGKm.png" alt="enter image description here"></p>