title: OPENJSON - How to extract value from JSON object saved as NVARCHAR in SQL Server
body: <p>There is a column <code>RawData</code> of type <code>NVARCHAR</code> which contains JSON object as strings</p>
  <pre><code>RawData 
  -------------------------------------------------------
  {&quot;ID&quot;:1,--other key/value(s)--,&quot;object&quot;:{--object1--}}
  {&quot;ID&quot;:2,--other key/value(s)--,&quot;object&quot;:{--object2--}}
  {&quot;ID&quot;:3,--other key/value(s)--,&quot;object&quot;:{--object3--}}
  {&quot;ID&quot;:4,--other key/value(s)--,&quot;object&quot;:{--object4--}}
  {&quot;ID&quot;:5,--other key/value(s)--,&quot;object&quot;:{--object5--}}
  </code></pre>
  <p>This JSON string is big (1kb) and currently the most used part of this json is <code>object</code>(200 bytes).</p>
  <p>i want to extract object part of these json strings by using <code>OPENJSON</code>.and i was not able to achieve a solution but i think there is a solution.</p>
  <p>The result that i want is:</p>
  <pre><code>RawData 
  ----------------
  {--object1--}
  {--object2--}
  {--object3--}
  {--object4--}
  {--object5--}
  </code></pre>
  <p>My attempts so far</p>
  <pre><code>SELECT * 
  FROM OPENJSON((SELECT RawData From DATA_TB FOR JSON PATH))
  </code></pre>