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 |