Translate

Wednesday 13 November 2013

Sort Order on column with multiple decimal places

SELECT *
FROM (
  VALUES
    ('1'),
    ('3.3'),
    ('1.1'),
    ('4.5.6'),
    ('1.4.3.1.1'),
    ('11.2')
) v (version)
ORDER BY
  CAST('/' + version + '/' AS hierarchyid)
;
Example: order by CAST('/' + ColumnName + '/' AS hierarchyid)

1 comment: