Another way of doing the same thing for SQL is to make a column for sorting and pad all numbers with zeros. So, 12R57B will become 0000012R0000057B.

While it probably doesn't matter for this column, do note that SQL Server has an nvarchar type that supports unicode. char and varchar store content in the local collation and thus are limited.