please ignore my earlier post and i have using sqlserver 2012..
I want to replace the values..
Table: student
ID studinfo
10 {"students":[{"Subjects_1":["science","Social"],"name":"??","subject_2":["Maths","language arts","social and club"],"subjects_3":["physical education","health","robotics and activities"],"studentName":"SamprasMat"}]}
Expected output:
ID studinfo
10 {"students":[{"Subjects_info":["All subjects"],"name":"??",studentName":"SamprasMat"}]}
I need a query to replace the strings..
Thanks for your help