By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| VALUE | PART1 | PART2 |
|---|---|---|
| A103B | A103 | B |
| 103C | 103 | C |
| FX104D | FX104 | D |
| Location2 | Location2 | null |
4 rows affected
| VALUE | PART1 | PART2 |
|---|---|---|
| A103B | A103 | B |
| 103C | 103 | C |
| FX104D | FX104 | D |
| Location2 | Location2 | null |