Oracle Case-When example

select
product,
company,
case when category = 'Microsoft'
then 'Yes!!'
else 'No'
end as microsoft_spotted
from
products
;