SELECT NVP2JSON( 'name->will+occupation->engineer+hair->blonde', '+', '->'); *** Query completed. One row found. One column returned. *** Total elapsed time was 1 second. NVP2JSON('name->will+occupation->engineer+hair->blonde','+','->') --------------------------------------------------------------------------- {"name":"will","occupation":"engineer","hair":"blonde"}