id--123AED20ERF....
select * from example Order By Case When IsNumeric(id) = 1 Then Right('0000000000000000000' + id, 20) Else id End
Login to post response