Answer
Use CHR(13) || CHR(10) together (carriage return plus line feed), not CHR(13) alone — comparing how a genuine multi-line address (like one pulled from Customer_Info_Address) actually renders at the byte level confirms it uses both characters together, not just a bare carriage return. Concatenating both characters at each line break in your Select Statement is what actually produces a visible line break in the rendered custom field.