NVP Function | VantageCloud Lake - NVP - Teradata VantageCloud Lake

Extracts the value of a name-value pair where the name in the pair matches the name and the number of the occurrence specified.

NVP is an embedded services system function.

To activate and invoke embedded services functions, see Embedded Services System Functions.

• NVP Function Syntax
• NVP Argument Types and Rules
• NVP Result Type
• NVP Function Examples

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.