Order by string same integer

mof400 · January 14, 2023, 3:45pm

hello frindes,
i want to roder the data same like photo

harishgg1 · January 14, 2023, 5:04pm

Hi Hope this helps

SELECT 
     order_by_column 
FROM 
    Table
ORDER BY 
       Cast ('/' + order_by_column + '/' AS  HIERARCHYID)

mof400 · January 14, 2023, 5:20pm

thank you very mach , it is don