Given a fairly simple table which holds only 2 columns I care about.Taco_Sales (Taco_Type varchar(20), Taco_Date datetime)I want to find the min and max Taco_date for a given taco type. Both Taco ...

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.