By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| string | a | b | c | d | output | string | a | b | c | d | output |
|---|---|---|---|---|---|---|---|---|---|---|---|
| X322-1-381128 | X322 | 1 | 38 | 128 | X322138128 | X322-1-383128 | X322 | 1 | 38 | 328 | X322138328 |
| string | CONCAT(LEFT(REPLACE('X322-1-381128', '-', ''), 8), RIGHT(REPLACE('X322-1-381128', '-', ''), 2)) |
|---|---|
| X322-1-381128 | X322138128 |
| X322-1-383128 | X322138328 |