sorting alphanumeric (or nvarchar) datatype

[premchandrasingh]

Hi,
I want to sort a column of datatype nvarchar in a proper sequence. The column could contain data 1, 2, 10,11,12,10A,20,21,20B,30,31..... I can't change the datatype too. I sort it upto the accuracy of 1,2,10,11,12,20,21,30,31,10A,20B using
"select * from MyTable where order by space(50-len(Column))+Column asc" query . But I want this in the follwing sequence
1,2,10,10A,11,12,20,20B,21,30,31

Please help me.

L. Premchandra Khaba