I have a query in a stored procedure trying to insert into this table some amounts:

| KPI | AMOUNT |
| --- | --- |
| First | - |
| Second | -100 |
| Third | 200 |

I'm trying to null all '-' records but when I replace it, it deletes the negative sign on the number too.

```
SELECT
    kpi,
    TO_NUMBER (REPLACE (amount, '-', NULL)),
FROM dual

```

| KPI | AMOUNT |
| --- | --- |
| First | null |
| Second | 100 |
| Third | 200 |

Any other idea to avoid this to happen and have this as result?

| KPI | AMOUNT |
| --- | --- |
| First | null |
| Second | -100 |
| Third | 200 |

Thanks!