Select JSON_VALUE(LastUpdate, 'strict $[10].Name.First') AS FirstName From Customers. Retrieving JSON Objects If what you’re interested in retrieving is a complete JSON object, you can retrieve JSON ...

This query, for example, finds all the rows in the Customers table that have a valid JSON object in their LastUpdate column: Select * From Orders.Customers Where (ISJSON(LastUpdate) > 0) Of course, it ...