I am trying to convert a column of zip codes into integers but I get a conversion error even when I casted the column correctly:

```
with zips as (
select  id ,cast(replace(replace(left(ltrim(Zip_Code),5), '-', ''), char(32), '0') as int) as zip_clean
from table1)

select * from zips 
    where zip_clean in 
    (19116,
    94595,
    60062)

```

Is there anything wrong with my nested cast function above?