I am writing a piece of code to populate a table and its not working, it keep sending error message like `Error converting data type varchar to numeric.`
Here is the table creation on MSSQL and here is the insert statement 

```
create table employee_pay_tbl
( 
    EMP_ID          varchar(9)   NOT NULL  primary key, 
    position        VARCHAR(15)  not null ,
    date_hire        date, 
    pay_rate         decimal (4,2),
    date_last_raise  date, 
    salary           decimal (8,2),    
    bonus            decimal (6,2),
    constraint  EMP_FK FOREIGN KEY (EMP_ID) REFERENCES EMPLOYEE_TBL(EMP_ID) 
);

```

This is the insert statement that's not working 

```
INSERT INTO employee_pay_tbl 
VALUES ('442346889','TEAM LEADER','2000-06-17','14.75','2009-06-01','NULL','NULL');

```

I tried to identify the offending value using this piece of code 

```
SELECT * FROM employee_pay_tbl WHERE isnumeric(bonus) = 0 AND bonus IS NOT null; 

```

I think the Date value is causing the error. How can I fix this?