title: Get value from array in JSON in SQL Server
body: <p>Let's say we have this json in our database table. I want to select value from tags. I already know how to get an array from this data but I don't know how to access array members. The question would be how do I get the first value from the array? Is there a function for this task?</p>
  
  <pre><code>{
      "info": {
          "type": 1,
          "address": {
              "town": "Bristol",
              "county": "Avon",
              "country": "England"
          },
          "tags": ["Sport", "Water polo"]
      },
      "type": "Basic"
  } 
  </code></pre>
  
  <p>Query I already have:</p>
  
  <pre><code>SELECT JSON_QUERY(MyTable.Data, '$.info.tags')
  FROM MyTable
  </code></pre>
  
  <p>This returns me:</p>
  
  <pre><code>["Sport", "Water polo"]
  </code></pre>
  
  <p>How do I get</p>
  
  <pre><code>Sport
  </code></pre>