>
> To me, it just doesn't sound right to sort a character field
> 1,2,10,12,20,21, whereas 01,02,10,12,20,21 does. If you still want

to do

> that, I suggest you do it through SQL by using CAST(<Field> AS

INTEGER) in

> your select statement(s) (possibly a hidden column only for the

sorting).

and I apologize for the strange requirements I have, but people would
like to differentiate between "01" and "1" (so padding is not
permitted) and some values may occur as "0123C" (so casting to
numeric doesn't work).

Seems this doesnt work....