This is the sample for your requirement; refer this and implement the same in your requirement.
declare @tab table
(
Id int,
name varchar(100)
)
insert into @tab
values (1,'n'),(2,'d'),(3,null),(4,'g'),(5,null)
select * from @tab
where name in ('n','d') or name is null