Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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?
like image 405
CheeseConQueso Avatar asked Dec 09 '08 19:12

CheeseConQueso


1 Answers

Nevermind... I figured it out...

its

(title1 || title2 || title3)

like image 79
CheeseConQueso Avatar answered Sep 28 '22 10:09

CheeseConQueso