Re: Concatenate within a Select?

Posted in 1997

pattersons@norand.com — 7 Jul 1997 10:43:14 -0400 — source: Informix-list mailing list archive (1991-1998)

Informix (and Oracle) use || for concatenation. Sybase and a few others use +. Scott Patterson Sr DBA Norand ______________________________ Reply Separator _________________________________ Subject: Concatenate within a Select? Author: roger@stratsoft.com (Roger Meyers) at smtpgate Date: 7/4/97 12:15 PM 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...