WHERE clause with '=' operator doesn't return exact match...

Multi-level hierarchy data display in SQL Server Management Studio...