forum

Home / DeveloperSection / Forums / Combining two columns data into one using SQL Server

Combining two columns data into one using SQL Server

Anonymous User207422-Sep-2014

I have a table:

CREATE TABLE CombineCoulmns(
       columnA varchar(15),
       columnB varchar(15)
)
 

With some records:

columnA              columnB

 

One                       Five                       

Two                       Six

Three                    Seven

Four                       Eight

 

I want to show the record as result as following:

comineColumn

One

Two

Three

Four

Five

Six

Seven

Eight

 

I attempt do this:

select columnA+columnB as combineColumn from CombineCoulmns;

 

but it give different Result:

 

comineColumn

OneFive

TwoSix

ThreeSeven

FourEight

 

Please help me.


Updated on 22-Sep-2014
I am a content writter !

Can you answer this question?


Answer

1 Answers

Liked By