null

Функции

coalesce

select
    coalesce(a, 'no')
from (
    values
        (null),
        ('yes'),
) t(a);
-------
no
yes

nullif

select
    nullif(a, 'no')
from (
    values
        ('no'),
        ('yes'),
) t(a);
-------
null
yes