Вставить строку в обратном порядке SQL server 1104/1100/1000 как это сделать с помощью hierarchyid ?

Ineed to write hierarchyid column from LTR not default state RTL by hierarchyid datatype

for example the default hierarchyid will shown as following :


AccountHierarchy	StringRepresentation	Name
/1000/1100/	           1100/1000	        Current Assets


I need to INSERT data inside hierarchy like StringRepresentation in table above

for example 1100/1000 so that 1100 came from 1000 but in hierarchyid it must written in reverse way /1000/1100/   so please how to solve this because its hard if my tree is so big

What I have tried:

Reverse() function not worked it reversed 1000 to 0001