By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| pozOfNumeric | leftPart | leftPartNoZero | finalString |
|---|---|---|---|
| 7 | abc000 | abc | abc12345 |
| 6 | abc00 | abc | abc1234 |
| 8 | abd0000 | abd | abd230440 |
| pozOfNumeric | leftPart | leftPartNoZero | finalString |
|---|---|---|---|
| 7 | abc000 | abc | abc12345 |
| 6 | abc00 | abc | abc1234 |
| 8 | abd0000 | abd | abd230440 |