Re: Concatenate within a Select?

Posted in 1997

David Williams — Fri, 4 Jul 1997 20:00:40 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <33be02e5.1596531@area1.news.internex.net>, Roger Meyers <roger@stratsoft.com> writes >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! > SELECT A, B, C, A || B Also can be used in SPL.. > >Roger Meyers >roger@stratsoft.com >Strategic Software Solutions >San Francisco... > > -- David Williams