RE: Insert/Select question in 4gl

Mickey, To concatenate two words together you use the syntax "col1 || col2" not "col1 + col2". Regards, David Ashby -----Original Message----- From: Mickey Mestel [mailto:mickm@ix.netcom.com] Sent: Monday, 7 September 1998 20:31 To: informix-list@iiug.org Subject: Insert/Select question in 4gl hi, i'm at a customers where in a 4gl program they are doing something like this: insert into table1 col1,..., name, ...coln values (select ..., first_name + last_name, ...from table2) so all they want to do is to concatenate the first and last name from table2, and put it into the name column of table1. this works fine in dbaccess, but doesn't in 4gl. we get a runtime error, which i just realized i don't have written down, but can get later if need be. this seems like it should be simple, but i haven't been able to figure it out in the few minutes i had to put into it. any ideas? mickm -- ----------------------------------------------------------------------- Note the new address: mickm@*ix*.netcom.com. of course, leave out the stars, those are just there for emphasis, oh, and leave off the period at the end of the com, that is just to denote the end of the sentence. So what you *really* want is mickm@ix.netcom.com Now why the hell didn't I just say that in the first place? It's a mystery... -----------------------------------------------------------------------