Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Taken from Oracle help documentation:
"NVL2 function extends the functionality found in the NVL function. It lets you substitutes a value when a null value is encountered as well as when a non-null value is encountered."
I would used an if statements testing for a null (or I actually prefer to test for a length of 0).
if(Len(MPS_ID)>0, 'MPS', 'NON MPS') AS MPS_FLAG
Jonathan
Hi,
Try this
If(IsNull(MPS_ID),'NON MPS','MPS') AS MPS_FLAG
Or If(Not IsNull(MPS_ID),'MPS','NON MPS') AS MPS_FLAG
And do not "Assumed Answered" when your issue is not resolve.
Regards,
Sokkorn