Re: Concatenate within a Select?

Posted in 1997

Kerry Sainsbury — Sat, 05 Jul 1997 20:59:24 +1300 — source: Informix-list mailing list archive (1991-1998)

In article <01bc88e6$6add87d0$0f02000a@crc3>, "Bob Carlton" <bcarlton@concentric.net> wrote: >Try the pipe character ( | ) Or even better, two of them: SELECT FirstName || " " || LastName FROM valued_customers WHERE IncomeBracket IN ("HUGE", "DECADENT", "OBSCENE") >Roger Meyers <roger@stratsoft.com> wrote in article ><33be02e5.1596531@area1.news.internex.net>... >> Hi! >> >> I feel like this has to be a dumb question, but I can't seem to find the >> answer... >> >> How do I tell a Select statement to concatenate 2 columns as a computed >> column? Something like SELECT A, B, C, A + B key_fields FROM ... the >> idea being to return one column, key_fields, that contains a and b >> concatenated together. (The plus causes an error.) >> >> Is there another concatenation symbol? Any suggestions? (Oh,... >> Informix Online 7) >> >> TIA! >> >> Roger Meyers >> roger@stratsoft.com >> Strategic Software Solutions >> San Francisco... ------------------------------------,------------------------------------------ Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.10 May 1997 Quanta Systems, Auckland | http://www.iiug.org/techinfo/faq/ New Zealand. Work: +64 9 377-4473 | ftp://ftp.iiug.org/pub/informix/faq Home: +64 9 279-3571 | ftp://kcbbs.gen.nz:/pub/informix/