Appending strings to columns

> > This bit of SQL doesn't work with Informix: > > update table1 set column1 = column1 || "a text string"> > Anybody know of a workaround? > > Paul Nailer > Try: SELECT column1 || "a text string" FROM table1 WHERE xxxxxxxx INTO temp x; UPDATE table1 set column1 = (select column1 from x) WHERE xxxxxxxx ; drop table x; j. _____________________________________________________________________________ Jack Parker | Hewlett Packard, BSMC Boise, Idaho, USA| He who talks most, talks least. jparker@hpbs3645.boi.hp.com | _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________