Re: Concatenate string in SQL update

Posted in 1999

Sujit.Pal@BankAmerica.com — Tue, 18 May 1999 13:47:53 -0700 — source: Informix-list mailing list archive (1991-1998)

Martin Use || to concatenate. Frex: Update table Set column = column || "extra text" HTH Sujit Martin Sandford <martin@audionri.enterprise-plc.com> on 05/18/99 08:01:05 AM Please respond to Martin Sandford <martin@audionri.enterprise-plc.com> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Concatenate string in SQL update Hi all I'm struggling to find an answer when I thought it would be simple .. I've got SQL/SE v4.1 I want to append some text to specific CHAR columns but I can not find the concatenate string operator. There must be one surely? Example Update table Set column = column + "extra text" The above fails because plus sign is arithmetic operator, therefore expression evaluates to null and I get error. I've tried & sign but this gives syntax error. Can find nothing in manuals. Thanks in advance Martin