This is a common problem when numeric data is stored as character and durai has posted one solution. Often in these types of applications the application will prepend 0's to the numeric value to get it sorting as desired as well. Also be aware that any index on ProdID will be sorted the way SQL Server is returning the data as well.