You can create table SizeOrder and use it to order result of a query.

* SizeOrder table
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