!!!NVL2 !Functionality: This Oracle function will return one of two values depending upon the value of the first parameter !Parameters: |StringValue | The variable you are working with |NotNullValue | The value you want to be returned if the variable is not NULL |NullValue | The value you want to be returned if the variable is NULL !Returns: String !Errors: None !Operations: If the first parameter is NOT null, then this function will return the value of the second parameter. If the first parameter IS a null value, then this function will return the value of the third parameter. !Example: {{NVL2(~,'DMZ','No')|| will evaluate the variable passed and if it is not NULL, will return DMZ. If it is null, then it will return No ---- ![Notes|Edit:Internal.NVL2] [{InsertPage page='Internal.NVL2' default='Click to create a new notes page'}]