By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| COL | ROUND(COL/POWER(10,TRUNC(LOG(10,COL))))*POWER(10,TRUNC(LOG(10,COL))) |
|---|---|
| 255 | 300 |
| 25555 | 30000 |
| 2444 | 2000 |
| 2555.5 | 3000 |
| COL | ROUND(COL/POWER(10,TRUNC(LOG(10,COL))))*POWER(10,TRUNC(LOG(10,COL))) |
|---|---|
| 255 | 300 |
| 25555 | 30000 |
| 2444 | 2000 |
| 2555.5 | 3000 |