Transact SQL :: Search A String In A Column Which Is Enclosed By Quotations

I need to categorize some rows of a column into specific type.  Criteria for the category search is to find a string which is enclosed at both the ends "_"

Example:
_you_,
are_you_,
are_you_jack

But when I give  condition like '%_you_% I end up getting records which are like "areyou_".

create table #test
(n varchar(30))

insert into #test values
('sql_2012'),
('ssis_msbi_'),
('ssrs_msbi'),
('ssasmsbi_')

select n,
case
when n like '%_msbi_%' then 'yes'
else 'no'
end as type
from #test

In the above query I need type as "yes" only for "ssis_msbi_". But the above query results with "yes" even for ssasmsbi_. What I need to do, to get just the data which has "_msbi_" in it.