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