Ordering Char/Number Combos...
I am using the following piece in my SELECT statement... I'm grouping and ordering rows by a number that identifies the card.
GROUP BY cardnumber, grade ORDER BY CAST(cardnumber AS UNSIGNED)
My "cardnumber" column is not an INT as some numbers have letters in them. When the combo begins with a number and ends with a letter... 34T it works.
However when I have cards numbered GG4 and GG5, its not ordering them correctly as GG5 shows in my table before GG4.
Any help would be appreaciated.