You mean somefunc? Yes. But I would end up with 21 sort fields.
>What I call yourfuncx() could probably be inline functions.
>>>I suggest that you select into a cursor, something like this semicode
>>>Select *,;
>>> somefunc1(yourfield) as sort1,;
>>> somefunc2(yourfield) as sort2,;
>>> somefunc3(yourfield) as sort3,;
>>> somefunc4(yourfield) as sort4;
>>> from yourtable into cursor yourcursor order by sort1,sort2,sort3,sort4
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]