select Hierarchy from [IMPS].[dbo].[test1] ORDER BY CAST('/' + Hierarchy + '/' AS HIERARCHYID)
SQL Server Developer edition 2008 R2
SQL server standard edition 2008 R2
select CAST('/' + Hierarchy + '/' AS HIERARCHYID) AS Hierarchy from [IMPS].[dbo].[test1] ORDER BY Hierarchy
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)