SQLTeam.com | Weblogs | Forums

Replace function help


#1

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


#2

That's not T-SQL what you have posted.

In T-SQL, you would use the REPLACE function.

SELECT REPLACE(SomeColumn, '.', '')
FROM Table1