Covert string to valid integer

select cast(coalesce(to_number('1a2'), -1) as int)