Results 1 to 5 of 5
Thread: Ordering Char/Number Combos...
Jan 9, 2010, 09:35 #1
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.Restaurant Takeout & Delivery Menus : Over 4500 Menus Online
Athletic Recruiting & Community for High School Athletes!