Alphanumeric Data sorting of Data from SQL Server 2008 R2

See more:

ASP.NET

SQL-Server

, +

Dear Friends,

I have a problem in the sorting of data coming from SQL Server 2008 R2 when the data is in this format:-

1). Female BC-1 Casting
2). Female BC-1 Pin Bush
3). Female BC-10 Casting
4). Female BC-10 Pin Bush Coupling

Like in the data above listed the listing should be in the order:-

1). Female BC-1 Casting
2). Female BC-10 Casting
3). Female BC-1 Pin Bush
4). Female BC-10 Pin Bush Coupling

What i have examined here that the string is in alphanumeric format so the order by clause is not able to sort it. But how to solve an alphanumeric string. Can any one suggest any solution for the same?

Thanks