> I'd like to select, (and order by), a formula .... > > SELECT (OHQTY * MLO_COST) as XTD_VALU > FROM ITEMMAST > ORDER BY XTD_VALU hi ron use ORDER BY N1, N2,... where the N's are the position numbers within the SELECT list of the columns you want to order by in your case ORDER BY 1 rudy r937.com