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 |