get flat value from json string sql server 2012 code example Example: jsonvalue sql JSON_VALUE(jsonInfo,'$.info.address[0].town')