Works perfect !! SELECT BILLCHARGE_ID, EXT_ATTR, json_extract(replace(replace(replace(EXT_ATTR, '{', '["'), '}', '"]'), ',', '","'), '$[9]') AS EXPRESION, replace( substr( substr(EXT_ATTR, instr(EXT_ATTR, '(') + 1), 1, instr( substr(EXT_ATTR, instr(EXT_ATTR, '(') + 1), ',') - 1), ')', '') EXPRESION2 FROM BILL_CHARGE WHERE BILLCHARGE_ID=751000000157777658 BILLCHARGE_ID EXT_ATTR EXPRESION EXPRESION2 751000000157777658 {,,,,,,,,,(11)24598458,100230,,1} (11)24598458 1124598458 Thanks you all!!