What I am doing is building a small inventory system for a tux rental place a friend owns. Let's say he's got 6 coats in stock of different sizes, here's an example of what it would look like now if I just do a normal sort by size:
Code: Select all
38L
38R
38S
38XL
B12
B8
Note: S = Short, R = Regular, L = Long, XL = Extra-Long, B = BoysCode: Select all
B8
B12
38S
38R
38L
38XLHow can I do this?
Someone on IRC suggested I split apart the letter and number... like one feild for 38, one for S... but the problem is there are over 600 coats in the table now, so that'd be a pain to go through and redo, plus, boys would still be on the bottom unless I inverted the list, then it'd all be upside-down.
Any ideas??
-ee99ee