NVP2JSON Example 1 - Teradata VantageCloud Lake

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"}