[RESOLVED] Walking a tree with HeirarchyID - SQLServer 2012

[CVMichael]

Is the format of HeirarchyPath really like this "1.3.1.2", because then you should be able to get the data by simply doing a search like
SELECT * FROM your_table WHERE HeirarchyPath LIKE '1.3.%'