Last updated 10 months ago
Replaces NULL with the specified replacement value. ().
Code:
Result:
No issues were found.
No related EWIs.
ISNULL ( check_expression , replacement_value )
NVL( <expr1> , <expr2> )
SELECT ISNULL(NULL, 'SNOWFLAKE') AS COMPANYNAME;
+-----------+ |COMPANYNAME| +-----------+ |SNOWFLAKE | +-----------+
SELECT NVL(NULL, 'SNOWFLAKE') AS COMPANYNAME;