-- NOTE: this is for SQL-Oracle specifically /* <...> : Your personal entry */ -- syntax: CAST( as ) -- in this case: = INTEGER -- example: SELECT CAST(MEMBER_NO as INTEGER) FROM DUAL;