How to use rownumber?

See more:

SQL

I will get one out put from this string @json1

{                
   "Status": "Success",                
   "Status Message": "Service Call Successful",                
   "Area":                
   [                
    
    {                
     "AreaCode":"A00009",                
     "AreaName":"BARSHI",                
     "FsCode":"TSM010",               
     "RegionCode":"R00001",                
     "RegionName":"MAHARASHTRA"                
   }, 
   {                
     "AreaCode":"A00008",                
     "AreaName":"BANGALORE",                
     "FsCode":"TSM040",               
     "RegionCode":"R00901",                
     "RegionName":"KARNATAKA"                
   },                              
    ]                
        }

now i want to replace last charecter ',' between '}' and ']' symbol any solution would be greatly appreciated..

What I have tried:

i have tried

set @json1=reverse(STUFF(REVERSE(@json1),charindex(',',@json1),1,''))

but no use..
i want out put like this

{                
   "Status": "Success",                
   "Status Message": "Service Call Successful",                
   "Area":                
[                
    
    {                
     "AreaCode":"A00009",                
     "AreaName":"BARSHI",                
     "FsCode":"TSM010",               
     "RegionCode":"R00001",                
     "RegionName":"MAHARASHTRA"                
   }, 
   {                
     "AreaCode":"A00008",                
     "AreaName":"BANGALORE",                
     "FsCode":"TSM040",               
     "RegionCode":"R00901",                
     "RegionName":"KARNATAKA"                
   }                              
   ]                
}