NVP Function

Database

NVP Function

Hi Below is the query:

I am trying to understand how NVP Function works. I tried the below simple query

SEL NVP('100:Jugal#9004','100','#',':',1)

Output:

Jugal

I want the output as

Jugal 9004(Name Value Pair)

Thanks

Jugal

Tags (1)