By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ADDRESS_1 | ADDRESS_2 | COMPNAME | ADDR_LN_1 | ADDR_LN_2 |
|---|---|---|---|---|
| PO BOX 123 | null | null | PO BOX 123 | null |
| COMPANY NAME ONE 1234 ROSE AVE | STE 100 | null | 1234 ROSE AVE | STE 100 |
| 456 PETUNIA WAY FIFTH FLOOR | null | null | 456 PETUNIA WAY | FIFTH FLOOR |
| COMPANY NAME TWO PO BOX 78910 | null | null | PO BOX 78910 | null |
| COMPANY NAME THREE 1112 DAISY ST THIRD FLOOR | null | null | 1112 DAISY ST | THIRD FLOOR |