Concatenate Return/LineFeed Characters in String

Posted in 1999

Cook, Russell L — Tue, 14 Sep 1999 09:58:07 -0700 — source: Informix-list mailing list archive (1991-1998)

How do you concatenate a "\\n" character in the middle of a string? This is a fragment in the stored routine I'm developing. This does not work. LET ship_addr = TRIM(addr1) || "\\n" || TRIM(addr2) || "\\n" || TRIM(city) || ", " || TRIM(state) || " " || TRIM(zip) || " " || TRIM(country); Appreciate all of your help. Thanks in advance. Russ