SQL character field concatenation (without using CONCAT() or +)

Question

I'm trying to concatenate 3 [char(32)] fields:

title1
title2
title3

into one field, but the catch is that I'm using an older version of SQL and it DOES NOT support the CONCAT() subroutine or the + operator

for example:
CONCAT(title1, title2, title3)
(title1 + title2 + title3)

DON'T WORK!!!!

Is there another way?

What database is it? I know you answered your own question, but if this is tagged with the appropriate RDBMS it will be easier for the next guy who has this issue to find your answer ... — John Rudy
– John Rudy, Commented Dec 9, 2008 at 20:28
And now you've told us Informix via the tags (and I spotted this Q quite quickly once it was tagged - but missed it when it wasn't), which version of Informix are you using? I'd suspect it must be OnLine 5.x, or possibly SE 7.2x. If it anything much else, you are long overdue for an upgrade. — Jonathan Leffler
– Jonathan Leffler, Commented Dec 18, 2008 at 23:57
im not sure which version... dont know where to find that info.. i just started working here 2 months ago and havent had time to care about that... upgrade? i hope so — CheeseConQueso
– CheeseConQueso, Commented Jan 12, 2009 at 21:15

CheeseConQueso · Accepted Answer · 2008-12-09 19:58:20Z

22

Nevermind... I figured it out...

its

(title1 || title2 || title3)

answered Dec 9, 2008 at 19:58

CheeseConQueso

6,07129 gold badges98 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bill Karwin Over a year ago

FWIW, that's the standard SQL syntax for string concatenation. It's weird that so many brands of database do something different.

Collectives™ on Stack Overflow

SQL character field concatenation (without using CONCAT() or +)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related