I have a table:

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

With some records:

 

One                       Five                       

Two                       Six

Three                    Seven

Four                       Eight

 

I want to show the record as result as following:

One

Two

Three

Four

Five

Six

Seven

Eight

 

I attempt do this:

select columnA+columnB as combineColumn from CombineCoulmns;

 

but it give different Result:

 

OneFive

TwoSix

ThreeSeven

FourEight

 

Please help me.