SELECT CAST(PROD_CODE AS INT) FROM PRODUCT
SELECT CAST(aField as UNSIGNED) from table; -- for VARCHAR use CHAR(50), INT use UNSIGNED