I'm trying to move data from a table with varchar columns to a table with numeric columns. Below is an example of values in a column, where sometimes a period will be used to denote a missing value.

```
    Column1
    0.00
    4.80
     .  
     .  
    0.00
     .  
    0.00
     .  

```

'Error converting data type varchar to numeric.' pops up when it reaches the periods. How can I deal with the periods (either removing them or changing them to 0.00) so that I can continue copying the data into the new table?

For reference, here is the code I am using:

```
    INSERT INTO [CORE]
       [NumberDone]
       ,[Charges]
    SELECT
       LEFT([Column0],8)
       ,LEFT([Column1],8)
    FROM [TempTbl];

```