Ive got table with null values in it. I would like to copy this table to another and replace null value from one column to for example 0. Is it possible cause my target table doesnt accept null values in this colum

`Insert into MyNewTable (A, B, C) select (AA, BB, CC) from MyOldTable`

And CC may be null

thanks for any help