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