Beginner Order By question....
I have a column in a table that is for weight classes (like in wrestling) that goes something like....
My problem is that I cannot store them as INT (or a number) because of the plus sign for the last weight class. So, when I have them ordered (ORDER BY weight ASC) it sorts them wrong.... sorts everything by the first number (like alpha if it was sorting text because it is stored as VARCHAR).
How can I get around this? I have to have the plus sign in the last record and INT or FLOAT will not accept the plus sign. Like I said, I'm a beginner, so I'm sure I am missing something very simple.
Thanks for helping me out.