SQL & PL/SQL

Hi All,
Does anyone know how to use cast in an insert statement ie

insert into myTable(fieldA)
select cast(fieldA as integer) from yourTable;

fieldA is an integer in myTable
fieldA is an varchar2(1) in yourTable

The actual values for fieldA in yourTable is 1 or 0.

Thanks!