How to replace NULL to specific string in snowflake (SQL)

user_10898011 0
Viewed 622

Does anyone know how to replace NULL to specific string in snowflake (SQL)?

Before

ID Name
1 Apple
2 NULL
3 NULL

After

ID Name
1 Apple
2 Not Defined
3 Not Defined

I would like to replace NULL with Not Defined.

Sincerely,

knozawa

snowflake-cloud-data-platform
1 Answers

NULL value could be replaced using the following functions: IFNULL/NVL/COALESCE:

SELECT ID, COALESCE(Name, 'Not Defined) AS Name
FROM tab
user_50708790
Related