I have a json array in my table. It contains an array. I can `create`, `append` or make my array `NULL`. Inside my stored procedure but I don't see any way to `pop` value from array. Apparently `JSON_Modify` may have solution as you can update `key` as well as **Single** `value` but how can I use it to modify my array?

```
--My Array 
Declare @json = '{"array":[123,456]}'

```

Desired results after update:

```
'{"array":[123]}'

```

Please note that `array` contain `int` values. Which are my `sub department id`. All values are (supposed to be) unique.