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 isNULL
from null_test;
select id, test
from null_test
where test = '';