select *
from SERVICE.mdb.dbo.hier
where upper(hier_parent) in
(
	select upper(hier_parent)
	FROM SERVICE.mdb.dbo.hier
	GROUP BY upper(hier_parent)
	HAVING (COUNT(UPPER(hier_parent)) > 1))