I would create a table with two columns: Size C(5) and SortOrder I and use it for sorting. Another way is to store sizes in a string in proper order and use AT() as sortorder.
lcSizes = ",XS,S,M,L,XL,2XL,...,"
? AT([,] + ALLTRIM(size) + [,], lcSizes)
>I'm in a data munging session, and this appeared a good time to ask.
>
>When using apparel sizing, my mind has no problem seeing XS, S, M, L, XL, 2XL, ... as fitting and proper. Any ideas on how to get this computer to think like I do?
--sb--