>>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)
>>
>
>OK, I thought about it ;-)
>
>#1 - perfect long term solution, easy to implement.
>
>#2 - also perfect for this munging session.
>
You're welcome. :-)
--sb--