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
NULL value could be replaced using the following functions: IFNULL/NVL/COALESCE:
SELECT ID, COALESCE(Name, 'Not Defined') AS Name
FROM tab