title: SQL switch latitude and longitude positions in the polygon string
body: <p>I have a text that contains polygon information</p>
  <p>Example data:</p>
  <pre><code>{&quot;points&quot;:[{&quot;lat&quot;:49.454912346,&quot;lng&quot;:-123.1000021159},{&quot;lat&quot;:47.454912346,&quot;lng&quot;:-122.1000021159},{&quot;lat&quot;:55.454912346,&quot;lng&quot;:-121.1000021159},{&quot;lat&quot;:52.454912346,&quot;lng&quot;:-127.1000021159},{&quot;lat&quot;:26.454912346,&quot;lng&quot;:-129.1000021159}]
  </code></pre>
  <p>it there any way that could swap &quot;lat&quot; and &quot;lng&quot; in this string in SQL Server?</p>
  <p>Expect outcome:</p>
  <pre><code>{&quot;points&quot;:[{&quot;lng&quot;:-123.1000021159,&quot;lat&quot;:49.454912346}
  </code></pre>
  <p>Any help appreciate!</p>