Link to home
Start Free TrialLog in
Avatar of ttist25
ttist25

asked on

SQL - Combine multiple fields from a table into a single column

Hello,

I'm trying to concatenate the values in multiple columns into a string in another column.

Here is some SQL:
CREATE TABLE #tmpExample ( 
    column1 varchar(255),
    column2 varchar(255),
    column3 varchar(255),
	column4 varchar(255)
);
INSERT INTO #tmpExample  
VALUES 
('1', 'A', 'B', 'C'),
('2', 'D', 'E', 'F'),
('3', 'G', 'H', 'I'),
('4', '', '4', 'ME');

ALTER TABLE #tmpExample
ADD columns2_4 varchar(255)

Open in new window


Given that data I would like to write a statement that results in the following in "columns2_4":
ABC
DEF
GHI
PIZZA4ME

I'm hungry right now and so I'm thinking ISNULL(COLUMN2, 'PIZZA').

Actually any NULL in column 2,3, or 4 should return pizza (I'm REALLY hungry).  

TIA!
ASKER CERTIFIED SOLUTION
Avatar of Brendt Hess
Brendt Hess
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ttist25
ttist25

ASKER

Great thanks Brendt!