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
Ryan.