By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
5 rows affected
| PRODUCTNR | REPLACE(TO_CHAR(PRODUCTNR/100,'FM99990.00'),'.','/') |
|---|---|
| 1 | 0/01 |
| 25 | 0/25 |
| 260 | 2/60 |
| 3700 | 37/00 |
| 51126 | 511/26 |
5 rows affected
| PRODUCTNR | REPLACE(TO_CHAR(PRODUCTNR/100,'FM99990.00'),'.','/') |
|---|---|
| 1 | 0/01 |
| 25 | 0/25 |
| 260 | 2/60 |
| 3700 | 37/00 |
| 51126 | 511/26 |