Hi Andrea,

I dont want to convert date time. I have column datatype varchar(30) and it contains both integer and varchar value but not alphanumeric (i.e. it can contain 1,2, 22, ABC but not Abc12 )

I want to sort that data.

Currently by default it sort like string i.e. in table we have value 2,11,42,7,1,abc,xyz etch and after sorting o/p is 1,11,2,42,7,abc,xyz.

But I want o/p should be like : 1,2,7,11,42,abc,xyz.

Please confirm if I am not able to understand your link properly.

Hii amit,

Refer the below link.

First Sort Numbers and then Alphabet Characters in SQL Query result