Answers for "How to use wildcard in Jason_VALUE"

How to use wildcard in Jason_VALUE

select json_value(t.trans_msg, '$.CheckDetails[0].CheckNumber'), -- works returns 101
       json_value(t.trans_msg, '$.CheckDetails[*].CheckNumber'), -- null returned      
       json_value(t.trans_msg, '$.CheckDetails[0,1].CheckNumber') -- null returned      
 from transactions t
where t.id = 1

How to use wildcard in Jason_VALUE

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