select
	name,
	case
		when has_filter = 0 then 'No'
		else 'Yes'
	end as Filter
from
	sys.indexes

select
	name,
	iif(has_filter = 0,'No','Yes') as Filter
from
	sys.indexes