SELECT field,CONVERT(field,UNSIGNED INTEGER) AS num FROM table;
SELECT CAST(PROD_CODE AS INT) FROM PRODUCT