• I was reading the same article, and inferred from the fact that it "is available to CLR clients as the SqlHierarchyId data type" that the CLR data type was in fact SqlHierarchyId.

    The representation used in the article suggest that is is some kind of string (as it mentions slashes etc.). The fact that you convert it to nvarchar by using the ToString method made me think it must, therefore, be a varchar type...

    Kelsey Thornton
    MBCS CITP