CODE EXAMPLE FOR JAVASCRIPT

How to use wildcard in Jason_VALUE

SELECT JSON_VALUE(@json,'$.Dims[0].Name');