create table null_test (
id int,
test varchar(64)
);
insert into null_test values (1, 'Test');
insert into null_test values (2, null);
insert into null_test values (3, '');
select id, test, case when test is null then 'test is NULL' else 'test NOT NULL' end
from null_test;