Help With SQL; order string data like numeric
Posted on 2015-01-22
I have a table of ages, infant, 1, 2... to 21. The data is text, because an age can be "infant". However, I would like SQL to sort the records with any instance of "infant" being first, and then as if the data was numeric.
Can this be done?