Hi Ryan,
Put size into separate field and you wouldn't have such problem.
>Hi Sergey,
>i used this command but it gives me nothing
>
>SELECT itmast.* ;
> FROM itmast ;
> JOIN SizeOrder ON size = PADR(CHRTRAN(itmcode, "HRN"+"1234567890", ""), 3) ;
> ORDER BY SortOrder
>
>TIA
>.
--sb--