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

sql string informix concatenation concat
CheeseConQueso picture CheeseConQueso · Dec 9, 2008 · Viewed 27.7k times · Source

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

CheeseConQueso picture CheeseConQueso · Dec 9, 2008

Nevermind... I figured it out...

its

(title1 || title2 || title3)

Related questions

UPDATE and REPLACE part of a string

I've got a table with two columns, ID and Value. I want to change a part of some strings in the second column. Example of Table: ID Value --------------------------------- 1 c:\temp\123\abc\111 2 c:\temp\123\abc\222 3 c:\temp\123\abc\333 4 c:\temp\123\…

Read More
Remove all spaces from a string in SQL Server

What is the best way to remove all spaces from a string in SQL Server 2008? LTRIM(RTRIM(' a b ')) would remove all spaces at the right and left of the string, but I also need to remove the …

Read More
How do I remove the first characters of a specific column in a table?

In SQL, how can I remove the first 4 characters of values of a specific column in a table? Column name is Student Code and an example value is ABCD123Stu1231. I want to remove first 4 chars from my table for …

Read More