Edit json

• farax_x

  Hall of Fame

  Points: 3579

  More actions

  April 25, 2017 at 8:01 am

  #321083

  Hi all,
   I have json like this
  \DECLARE @j NVARCHAR(max) = N'[{"Views":1,"Date":1493119613,"MediaCaption":"test"}]'


  I want to edit "MediaCaption" value. this query doesnt work because its array :
  
SET @j = JSON_MODIFY(@j,'$.MediaCaption' , N'hi')
SELECT @j

  how can I do this?
  

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  April 25, 2017 at 8:46 am

  #1939772

  Something like this?
  SET @j = JSON_MODIFY(@j,'$[0].MediaCaption' , N'hi')

  ---