By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| sql |
|---|
| select substring(code, 1, 3) col1, substring(code, 4, 3) col2, substring(code, 7, 3) col3, substring(code, 10, 3) col4 from mytable |
| col1 | col2 | col3 | col4 |
|---|---|---|---|
| ABC | DEF | GHI | |
| XYZ | ABC | ||
| JKL | MNO | PQR | STU |
| ABC | DEF |