Hello, I have sorting problem with a column in the database (string) that stores alphanumeric data. The data is A1, A2, A3..A10, A11, A12.
When I sort by column type, I get A1, A10, A11, A12 but I would like to get A1, A2, A3...A10, A11, A12. Is there anything I can try with orderby="columntype"? What other kind of operations does orderby allow? (I saw field.upper and field.month). Thanks, Sebastian