You can create table SizeOrder and use it to order result of a query.
SIZE C(3) SortOrder C(1)
S 1
M 2
L 3
XL 4
XXL 5
SELECT mytable.* ;
FROM mytable ;
JOIN SizeOrder ON size = PADR(CHRTRAN(myfield, "1234567890", ""), 3) ;
ORDER BY SortOrder
>Hi to All,
>
>anyone who can help me to view my records in this way.is it possible?
>
>1110S
>1110M
>1110L
>1110XL
>1110XXL
>
>co'z when i retreive the records it will display
>
>1110L
>1110M
>1110S
>1110XL
>1110XXL
>
>i want to arrange it in small,medium and large.
>
>TIA
>Ryan
--sb--