DB2

How to concatenate multiple columns in a DB2 select statement to return a single column

12/03/2013 Mark Jacobsen 3 Comments

Use “||” like so…

SELECT LastName||', '||FirstName 
FROM [schema].[table]

If one of the columns is numeric you’ll probably want to convert to CHAR and TRIM like so…

SELECT LastName||', '||FirstName||' - '||TRIM(CHAR(EmplId))
FROM [schema].[table]

Please remember to subscribe to the newsletter or feed to stay up to date!

Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself.

3 thoughts on “How to concatenate multiple columns in a DB2 select statement to return a single column”

anonymous says:

11/03/2016 at 2:28 am

Thanks this post helped me

Reply
Anonymous says:

03/01/2018 at 9:34 pm

Awesome … it worked great!

Reply
Wilbert Laurent says:

04/30/2019 at 4:45 pm

Thanks!!! it worked to perfection…

Reply