Re: Concatenate string in SQL update
From: Martin Sandford <martin@audionri.enterprise-plc.com> > >I'm struggling to find an answer when I thought it would be simple .. > >I've got SQL/SE v4.1 It goes without saying that you're aware you're almost certainly not Y2K compliant? >I want to append some text to specific CHAR columns but I can not >find the concatenate string operator. There must be one surely? Try || (I'm guessing here, I actually don't remember if there was one on such an old version! :-) >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 ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
Obnoxio The Clown wrote: > Try || > > (I'm guessing here, I actually don't remember if there was one on such an > old version! :-) > In fact, there wasn't :-) Ciao, Marco ______________________________________________________________________________ Marco Greco <marco@informix.com> Standard disclaimers apply! Informix faq http://www.iiug.org/techinfo/faq/informix.htm 4glworks http://www.ctonline.it/~marcog Informix on Linux http://www.ctonline.it/~marcog/ifmxlinux.htm
Obnoxio The Clown wrote: > > From: Martin Sandford <martin@audionri.enterprise-plc.com> > > > >I'm struggling to find an answer when I thought it would be simple .. > > > >I've got SQL/SE v4.1 > > It goes without saying that you're aware you're almost certainly not Y2K > compliant? > (snipped) Interesting point. We are discussing this at the moment here. In October 1997 newsgroup discussions suggested I would be definately compliant. My own (brief) tests supported this. More recently Informix Yk2 web site says I have a not-supported product because it has entered Category Four. They don't actually say it is not compliant, they just say it's not supported and they will not provide Yk2 info. Our choices seem to be either to trust our own brief tests or find over 5000 UK pounds (from somewhere!) to upgrade. Martin