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

Question

Hey..

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?

Answer 1

Nevermind... I figured it out...

its

(title1 || title2 || title3)