RE: Concatenate string in SQL update

Posted in 1999

Howard, Paul — Tue, 18 May 1999 15:37:33 -0400 — source: Informix-list mailing list archive (1991-1998)

Although the comma concatenates in 4GL the || (double pipe) concatenates in SQL. -----Original Message----- From: Mark Roach [SMTP:mroach@bju.IT5_PO] Sent: Tuesday, May 18, 1999 3:04 PM To: informix-list@iiug.org Subject: Re: Concatenate string in SQL update This is a multi-part message in MIME format. --------------2E53C1C62264E667095E3AD9 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I believe the comma is the operator your looking for. Martin Sandford wrote: > 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 --------------2E53C1C62264E667095E3AD9 Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Mark Roach Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Mark Roach n: Roach;Mark org: Bob Jones University email;internet: mroach@bju.IT5_PO title: Informix Programmer x-mozilla-cpt: ;0 x-mozilla-html: FALSE version: 2.1 end: vcard --------------2E53C1C62264E667095E3AD9--