How can you implement custom sort on SQL column?

Question

How can you implement custom sort on SQL column? Based on 1. Small case Caps and then number. 2. Caps small case then number Considering following table with one column and values given. TestData table Data A b a G H 1 s 3 4 9 Looking for simple approach.

mahesh sharma · Answer

Use below script select ASCII(col1)col1 from ( select 'A' col1 union all select 'b' union all select 'a' union all select 'G' union all select 'H' union all select '1' union all select 's' union all select '3' union all select '4' union all select '9' )v1 order by ASCII(col1) select ASCII(col1)col1 from ( select 'A' col1 union all select 'b' union all select 'a' union all select 'G' union all select 'H' union all select '1' union all select 's' union all select '3' union all select '4' union all select '9' )v1 order by ASCII(col1) desc Thanks Mahesh

Rajkiran Swain · Answer

https://sqlperformance.com/2016/10/sql-plan/implementing-custom-sort https://stackoverflow.com/questions/7862578/custom-sorting-in-sql-order-by-clause