Sort Numbers and then Alphabet Characters in SQL Server

Last Reply on Jul 29, 2016 04:20 AM By dharmendr

Posted on Jul 29, 2016 12:37 AM

HI,

I have data in sql like :

1

ABC

12 and so on

 

I want to sort it first numerically and once numeric value finished it should display string in in order

O/P should be like : 1 2 12 ABC

not 1 12 2 ABC

 

Thnaks in Advance :)

 

You are viewing reply posted by: dharmendr on Jul 29, 2016 04:20 AM.
Posted on Jul 29, 2016 04:20 AM